Find out the MySQL version

There are at least three types of MySQL. These are the original one from Oracle, MariaDB from the developer of the original one, which appeared after it became owned by Oracle, and PerconaDB, a fork with its own storage engine. Each kind has several actual versions, which may come by default depending on your distribution. Next, let's look at how to find out the version. The version determines the supported features as well as some limitations.

How to determine the version of MYSQL

The best way to find out the version if you have access to the server is to run the mysqld command with the --version option:

$ mysqld --version

In this case, MariaDB 10.3 is installed. If you have a username and password to access the database, you can connect to it using the console client. It too outputs the server version when you connect. For example:

$ mysql -u user_name -h хост -p

Or:

$ sudo mysql -u root

You may have connected to the server and want to see the version, use a command like this:

$ mysql> SELECT VERSION();

You can see the value of the version variable:

mysql> SHOW VARIABLES LIKE '%version%';

If you don't have access to the database server and can't connect to it using a terminal, you can still view the version using PhpMyAdmin. It is necessary to have authorization data. Just authorize in the program and on the main page, in the Database Server section you will see the necessary information.

To find out the version is simple This task can be solved in many ways, and it displays not only the version but also the name of the variety of the database. For example, MariaDB or Percona.