How to Check MySQL Version

MySQL is an relation database management system. At the writing time of this tutorial MySQL 8 is the latest version available. This tutorial help you to check MySQL server version running on your system.

• Install MySQL on Ubuntu 20.04
• Install MySQL on Debian 10

Method 1 – Check MySQL Version (Local)

Use mysqld command with -V option to check MySQL version running on local host system. The below examples can only used for the localhost only.

mysqld -V 

Output>
mysqld  Ver 5.7.32-0ubuntu0.16.04.1 for Linux on x86_64 ((Ubuntu))

The above result shows that you are running MySQL version 5.7.32 on your local system.

Method 2 – Check MySQL Version (Local & Remote )

You can also check MySQL version with login to mysql command line interface. When we connect to mysql shell, it displays a welcome message including the MySQL version running on system.

This method can be used to check MySQL version running on local host as well as on remote host.

mysql -u root -p 

Conclusion

This tutorial help you to check MySQL version running on local host or on remote host.