User Tools

Site Tools


How to Check MySQL Version via the Commandline

In this tutorial we are going to learn how to check the MySQL version for a specific server. MySQL is the most popular Relational Database Management System in use today, and is going to be used in some form on any Linux-based webserver. Knowing which version you are currently using is important, as some important features and configurations change based on the MySQL server version.

Please note that the instructions provided in this short document work for both MySQL and MariaDB. The relevant differences will be explained later on.

via SSH Shell

Once you have logged in to the server via SSH type the command: mysql -V. Here are the command and its results:

Please note the version highlighted in red: 5.6.38.

via MySQL Shell

You could also check the MySQL version from the MySQL shell. You can enter the MySQL shell by typing mysql at the command prompt:

Once you are in the mysql shell you can execute the following command:

"show variables  like '%version%';"

which is going to show the server's version:

MariaDB or MySQL?

MariaDB is a community-developed fork of the MySQL relational database management system intended to remain free under the GNU GPL. Development is led by some of the original developers of MySQL, who forked it due to concerns over its acquisition by Oracle Corporation.

What does this mean? From the user point of view, nothing; MariaDB 10.0 is an out-of-the-box upgrade for MySQL 5.6, so none of your applications and sites should notice any differences when using MariaDB.

developmental/mysql/check-version-cli.txt · Last modified: 2018/02/02 14:54 by Marjorie S.