Ways to check mysql version in linux

Ways to Check MySQL Version in Linux

Introduction

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:

kusal@linuxways:~$

Sponsored
mysql -V

Ways to check mysql version in linux 33

To ascertain the server version, run the binary with the –version or -V lines as shown below:

Ways to check mysql version in linux 34

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:

kusal@linuxways:~$ mysqladmin -V

Ways to check mysql version in linux 35

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.

kusal@linuxways:~$ 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:

Ways to check mysql version in linux 36

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:

mysql>status

Ways to check mysql version in linux 37

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%";

Ways to check mysql version in linux 38

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.

Ways to check mysql version in linux 39

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.

See also  Monitor Network Traffic with vnStat on Ubuntu 20.04

Ways to check mysql version in linux 40

Conclusion

The article gives you an idea on what are the ways to check the MySQL version in Linux. Thank you for reading.

Karim buzdar

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.


Discover more from Ubuntu-Server.com

Subscribe to get the latest posts sent to your email.

Comments

No comments yet. Why don’t you start the discussion?

    Leave a Reply