MySql is a relational database management system that permits users to organize data in the database. Knowing which MySQL version is running on your server may be useful in some cases due to certain differences between MySQL versions. If you’re installing an application that requires a specific MySQL version, for example, you’ll need to know what version of MySQL your MySQL server is before you start.
In this article, I will provide you with different ways to check the MySQL version in Linux.
How to check the MYSQL version
Using the command line, you can check the MYSQL version
Enter the following command into your terminal:
[email protected]:~$ mysql -V
To ascertain the server version, run the binary with the –version or -V lines as shown below:
Note: Before quitting, the command above will indicate the version of MySQL installed.
To determine the installed MySQL version, use the following command with the mysqladmin program:
[email protected]:~$ mysqladmin -V
Using the MYSQL shell, you can check the MYSQL version
The MySQL utility command client is used to find out what version of MySQL your operating system has installed. On the MySQL shell, use the following command to connect to the MySQL server.
[email protected]:~$ sudo mysql
Once the server has been connected to the MySQL shell, the MySQL version will be displayed on the screen, as shown in the image below:
The status command displays the current status of the server, as well as the MySQL version.
To use the status command, run the following command:
Use the query version variables as suggested to acquire more information about the MySQL installed version and all of its related components:
mysql> SHOW VARIABLES LIKE "%version%";
Using MySQL Workbench, you can check the version of MySQL.
Another way to check the version of MySQL installed on your machine is to use MySQL Workbench. Connect to the server using MySQL Workbench and then proceed as follows:
On the MySQL workbench main menu, select the server. Select “Server Status” from the drop-down menu. Both the server information and the MySQL version will be displayed in the server status.
Using PHP, you can check the version of MySQL
If you’re on a shared hosting account and don’t have access to a command line or a MySQL client like PhpMyAdmin, you can use PHP to find out what MySQL server version you’re running.
The article gives you an idea on what are the ways to check the MySQL version in Linux. Thank you for reading.
Karim Buzdar holds a degree in telecommunication engineering and holds several sysadmin certifications including CCNA RS, SCP, and ACE. As an IT engineer and technical author, he writes for various websites.