How to check the MySQL version?

We can check the MySQL version on Linux using the below command:

  1. mysql -v  

If we use the MySQL in windows, opening the MySQL command-line tool displayed the version information without using any flags. If we want to know more about the server information, use the below statement

  1. SHOW VARIABLES LIKE “%version%”;  

It will return the output as below:

MySQL Interview Questions

In this output, we can see the additional version information about the installed MySQL software like innodb_version, protocol_version, version_ssl_library, etc.