MySQL - how to check database version

MySQL - how to check database version

Colleagues hello to all.

In today's article, we'll talk about how you can quickly check which Mysql DBMS you have installed on a Linux server. There are times when you are handed over a database for support, or you want to upgrade your database version but don't know which version you have installed.

 

The first way to check is to connect to the console through the mysql utility and run the command:

mysql> SELECT version();

mysql_version


 

The second option is to run the command in the terminal:

$. mysql -V

mysql_version


 

The third option to check is to connect to the console through the mysql utility and run the command:

mysql> SHOW VARIABLES LIKE "version";

mysql_version


 

Thank you all, I hope that my article helped you in some way.

 

SIMILAR ARTICLES

MySQL - Test Data Generation
MySQL - Test Data Generation
MYSQL
Read more
MySQL / MariaDB How to get the id of the last inserted record in a table - LAST_INSERT_ID
MySQL / MariaDB How to get the id of the last inserted record in a table - LAST_INSERT_ID
MYSQL
Read more
MySQL/MariaDB How to convert character case - UPPER and LOWER functions
MySQL/MariaDB How to convert character case - UPPER and LOWER functions
MYSQL
Read more