Best Ways to Check MySQL Version

Best Ways to Check MySQL Version
Best Ways to Check MySQL Version

Check MySQL Version

MySQL is opensource and one of the most popular and widely used database management systems. Sometimes we stuck in checking the version of the software we are using in different Linux distros like Ubuntu, Debian, RedHat etc. In this tutorial, you are going o learn Best Ways to Check MySQL Version.

Prerequisites

Before you start to install MySQL on Ubuntu 18.04. You must have the root user account credentials of your system.

1. First Way

Linux terminal is the easiest way to check MySQL version which can work on any Linux distribution. To check version run below command:

mysql -V

The output should be:

"Best

The above method works on any Linux distribution.

2. Second Method

You can also check the MySQL version by using MySQLAdmin in the terminal.

Now to check version using MySQLAdmin run below command:

mysqladmin --version

The output should be:

"Best

The above method works on any Linux distribution.

3. Third Way

In this method, you should log in to MySQL terminal. Run below command to log in to MySQL:

sudo mysql -u root -p

After logging in run below command:

SHOW VARIABLES LIKE "%version%";

The output should be:

"Best

The above method works on any Linux distribution.

Conclusion

You have successfully learned Best ways to check the MySQL version. If you have any queries please don’t forget to comment out.

LEAVE A REPLY

Please enter your comment!
Please enter your name here