How to Check MySQL Version

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.

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 

How to Check MySQL Version

Conclusion

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

The post How to Check MySQL Version appeared first on TecAdmin.

mysql version