How to check MySQL version

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

Terminal

$ mysql -V

mysql  Ver 8.0.18 for Linux on x86_64 (MySQL Community Server - GPL)

The above output show MySQL version 8.0.18 is installed on the server.

Server System Variables

Alternatively, we can connect to MySQL and use show variables to display the MySQL server system variables.

Terminal

$ sudo mysql -u root -p

mysql> show variables like "%version%";
+--------------------------+-------------------------------+
| Variable_name            | Value                         |
+--------------------------+-------------------------------+
| immediate_server_version | 999999                        |
| innodb_version           | 8.0.18                        |
| original_server_version  | 999999                        |
| protocol_version         | 10                            |
| slave_type_conversions   |                               |
| tls_version              | TLSv1,TLSv1.1,TLSv1.2,TLSv1.3 |
| version                  | 8.0.18                        |
| version_comment          | MySQL Community Server - GPL  |
| version_compile_machine  | x86_64                        |
| version_compile_os       | Linux                         |
| version_compile_zlib     | 1.2.11                        |
+--------------------------+-------------------------------+
11 rows in set (0.04 sec)

References

mkyong

Founder of Mkyong.com, passionate Java and open-source technologies. If you enjoy my tutorials, consider making a donation to these charities.

0 Comments
Most Voted
Newest Oldest
Inline Feedbacks
View all comments