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
Conclusion
This tutorial help you to check MySQL version running on local host or on remote host.
Leave a Reply