A popular question when troubleshooting database issues is what version of mySQL is installed and used?
You can find this information by running a simple command on the mySQL server.
Connect to your MySQL engine with your favorite client, why not use MySQL Workbench. Execute the following command and it will give you all the necessary information related to MySQL Version.
1 |
SHOW VARIABLES LIKE "%version%"; |
Here is the screenshot of the result which I receive when I ran above command on one of my servers.