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.