How to determine your MySQL or MariaDB version number Updated on June 29, 2022 by Scott Mitchell 1 Minutes, 6 Seconds to Read When working with phpMyAdmin and PHP, you will often use a programming language called SQL, which is the way your program will talk to your database. This language talks through a system called MySQL or MariaDB to update, create, and delete information from the program’s databases. At times, you may end up troubleshooting various errors such as syntax errors for MySQL within your PHP code or phpMyAdmin tool. It can be helpful to understand which version of MySQL or MariaDB you are using. Below is a quick guide on finding the version in use on your hosting servers. MySQL came first. A few years ago, MariaDB was created as an open-source fork of MySQL to make sure that an open source database management system remained available. There are a few small differences between the two, but they remain very similar. Most InMotion Hosting servers currently use MariaDB. Finding your MySQL or MariaDB version via phpMyAdmin Log into your cPanel admin dashboard. From the main cPanel area, look for the Databases category. Find and click on phpMyAdmin. From the main phpMyAdmin page, look to the far right side of the page. There is a block entitled “Database Server”. Look for the field named Server version or Software version. Next to that label is a number. That is your MySQL or MariaDB version number. Share this Article Related Articles Database Optimization: Tips Using MySQL Tuner How to Check and Repair a Database in phpMyAdmin Create a blank database How to Create a MySQL Database Using CLI & cPanel How to Connect to a Database with MySQL Workbench Setting up a Remote MySQL Database Connection MySQL 1064 Error: You have an error in your SQL syntax Using MySQLi to INSERT Data into a Database How to get PostgreSQL on a VPS / Dedicated Server What is MariaDB?
I can create a database but when it comes to saving a table, it brings a syntax error 1064 that I need to find a manual that correspond with the version of mariadb now I don’t know what this means and how I can possibly resolve this error.
I have seen instances where this is caused by having more opened than closed parenthesis in your syntax. Here is a helpful link to the official MariaDB knowledge base where they cover Parenthesis including this syntax error.
Hi Tom, and thanks for pointing that out. This article is a bit out of date, I’ll get it updated to account for that and the newer versions of cPanel. Some of our servers now use MariaDB, which is an open source fork of MySQL that works almost the same way but is designed to be maintained as an open source project.
