MySQL is one of the most popular open-source database management systems and is used by many websites and organizations. There are a lot of MySQL versions available on the Internet. If you want to host an application that requires a specific MySQL version, you will need to know the version of MySQL installed on your server.
In this post, we will show you how to check the MySQL version in Linux.
Check the MySQL Version via Command Line
The simple and easiest way to check the MySQL version on your system is from the command line. If you have root access to your Linux server, you can use the following command to check the MySQL version:
mysql -V
You will get the MySQL version in the following output:
mysql Ver 8.0.26 for Linux on x86_64 (Source distribution)
MySQL also provides a MySQLAdmin command-line utility to perform several administrative tasks. You can also use this utility to check the MySQL version:
mysqladmin -V
You will get the following output:
mysqladmin Ver 8.0.26 for Linux on x86_64 (Source distribution)
Also Read
Check MySQL Version Using SHOW VARIABLES
You can also use the MySQL command-line utility to check the MySQL version.
First, connect to the MySQL server with the following command:
mysql -u root -p
Once you are connected, use the following command to check the MySQL version:
mysql> SHOW VARIABLES LIKE '%version%';
You will get the MySQL version in the following output:
+--------------------------+-------------------------------+ | Variable_name | Value | +--------------------------+-------------------------------+ | admin_tls_version | TLSv1,TLSv1.1,TLSv1.2,TLSv1.3 | | immediate_server_version | 999999 | | innodb_version | 8.0.26 | | original_server_version | 999999 | | protocol_version | 10 | | replica_type_conversions | | | slave_type_conversions | | | tls_version | TLSv1,TLSv1.1,TLSv1.2,TLSv1.3 | | version | 8.0.26 | | version_comment | Source distribution | | version_compile_machine | x86_64 | | version_compile_os | Linux | | version_compile_zlib | 1.2.11 | +--------------------------+-------------------------------+
Also Read
How to Create and Delete User in MySQL
Check MySQL Version Using SELECT VERSION
After connecting to the MySQL server, you can also use the SELECT VERSION command to check the MySQL version.
mysql> SELECT VERSION();
You will get the following output:
+-----------+ | VERSION() | +-----------+ | 8.0.26 | +-----------+ 1 row in set (0.00 sec)
Check MySQL Version Using STATUS
You can also run the STATUS query inside the MySQL shell to check the MySQL version:
mysql> STATUS;
You will get the following output:
-------------- mysql Ver 8.0.26 for Linux on x86_64 (Source distribution) Connection id: 11 Current database: Current user: root@localhost SSL: Not in use Current pager: stdout Using outfile: '' Using delimiter: ; Server version: 8.0.26 Source distribution Protocol version: 10 Connection: Localhost via UNIX socket Server characterset: utf8mb4 Db characterset: utf8mb4 Client characterset: utf8mb4 Conn. characterset: utf8mb4 UNIX socket: /var/lib/mysql/mysql.sock Binary data as: Hexadecimal Uptime: 2 min 12 sec Threads: 2 Questions: 17 Slow queries: 0 Opens: 150 Flush tables: 3 Open tables: 66 Queries per second avg: 0.128 --------------
Check MySQL Version Using PHP
If your application is hosted on the shared hosting and doesn’t have access to the command line, you can upload the PHP file to your website directory and check the MySQL version.
To check the MySQL version using PHP, create a file named info.php with the following content and upload it to your website directory:
<?php
// Create a database connection.
$link = mysqli_connect("localhost", "root", "securepassword");
// Print the MySQL version.
echo mysqli_get_server_info($link);
// Close the connection.
mysqli_close($link);
Next, open your web browser and access info.php file using the URL http://your-website-name/info.php. This will display the MySQL version on your web browser screen.
Conclusion
In this post, we explained several methods to find out the MySQL version in your Linux system. You can now choose your preferred method to check the MySQL version. Try MySQL on VPS hosting from Atlantic.Net!
