4 Ways to Check MySQL or MariaDB version on Linux

This tutorial will let you know the key commands or ways we can use to check the MySQL or MariaDB Database server version running on Linux operating systems such as Debian, Ubuntu, CentOS, Rocky Linux, AlmaLinux, and more.

If you have already done the installation of MySQL or MariaDB server on your Linux. Then now you probably have a question about how to check which version you are actually using?

Also, MySQL is one of the popular and most common database servers using around the world to store data. However, don’t be confused between MySQL and MariaDB because the latter one is the fork of MySQL, nothing more than that. Hence, the commands used for Oracle MySQL will also be applicable for MariaDB.

Command to Check MySQL or MariaDB Database server version

 

On your command terminal use the Database CLI tool:

If you already have the database server or just installed MySQL or MariaDB then we already have a built-command tool to create and manage the database. And the same can be used to check the version as well.

mysqld --version

or

mysqladmin -V

 

Check version using Mysql shell:

You can switch to MySQL shell to create a database, the same we can be used to get the details of the version.

sudo mysql

Get mySQL version

 

Use the Status command:

If you want to use the MySQL command syntax to get the complete status including a version of the database, then use the “STATUS” command, once you logged in, using the sudo mysql:

STATUS;

This method also provides the exact version of the Server OS, current user, Connection, and other details.

Command to show MariaDB or MySQL version

 

Use phpMyAdmin to find the MySQL database server version.

If you are using phpMyAdmin, then you don’t need to go anywhere else. Simply, login to your phpMyAdmin, and on the left side of Dashboard, you will get all key details including the version of MySQL or MariaDB.

Use PHPMyADMin to find MySQL database version

 

Well, these are not the only methods to check the version of MySQL, yet they are the common and easy ones. Also, you don’t need any extra GUI or CLI tools to run the above-given commands. Nevertheless, if you are using some other way to find your database server version, then share that with us; the comment section is all yours.

 

Other Articles:

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.