4 Detailed Ways to Check The MySQL Version in Linux
Introduction
MySQL is a widely used open-source database management system that powers numerous websites and organizations. It was initially released in 1995, and since then, several versions have been developed.
Knowing the version of MySQL you are using is crucial for making necessary configuration changes and optimizing settings to ensure the optimal performance of your applications.
In this post, we will guide you on how to check the MySQL version in Linux, simplifying the process for you.
Prerequisites
– Servers running any Linux operating system
– Install and run the MySQL server
– The root password configured on your server
How to Check The MySQL Version in Linux?
1. Check MySQL Version in The Login Log
When you log in to your MySQL in Linux, the login log will display your MySQL version number, as shown in the figure below.
2. Check MySQL Version Using STATUS
If you have logged in to MySQL, you can enter ‘STATUS’ in the command window to check your MySQL version number. This command will output more detailed MySQL database information, as shown in the picture below.
MySQL> STATUS
3. Get MySQL Version Using SELECT VERSION
If you are already connected to your MySQL server, you can also use the SELECT VERSION command to check the MySQL version.
MySQL> SELECT VERSION();
4. Find The MySQL Version via Command Line
The easiest way to check the version of MySQL on your system is from the command line. If you have root access to a Linux server, you can check the MySQL version with the following command:
MySQL> mysql -V
You will get the following output:
mysql Ver 8.0.34-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
MySQL also provides the MySQLAdmin command-line utility to perform several administrative tasks. You can also check the MySQL version with this utility:
mysqladmin -V
You will get the following output:
mysqladmin Ver 8.0.34-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))
Conclusion
We have provided you with multiple methods to determine the MySQL version in your Linux system. Now you can conveniently choose the method that suits your preference to check the MySQL version. Additionally, if you’re looking for VPS hosting that supports MySQL, we recommend trying out Database Mart for a reliable and efficient hosting solution.
