check mysql version_How to check MySQL version

In terminal, type mysql -V (uppercase V) to display the current MySQL version installed on the server.

Terminal

$ mysql -V

mysql Ver 14.14 Distrib 5.7.24, for Linux (x86_64) using EditLine wrapper

Alternatively, log into the MySQL console and issue the MySQL command like this :

Terminal

$ mysql -u root -p

mysql> SHOW VARIABLES LIKE "%version%";

+-------------------------+------------------------------+

| Variable_name | Value |

+-------------------------+------------------------------+

| innodb_version | 5.7.24 |

| protocol_version | 10 |

| slave_type_conversions | |

| tls_version | TLSv1,TLSv1.1 |

| version | 5.7.24 |

| version_comment | MySQL Community Server (GPL) |

| version_compile_machine | x86_64 |

| version_compile_os | Linux |

+-------------------------+------------------------------+

8 rows in set (0.00 sec)

References