In this article, we will see how to check the MySQL version in different ways.
Table of Contents:-
MySQL check version query
In this section, we will be looking into how to check the current version of your MySQL server using a query. Observe the below query.
Similarly, we can also use:
We can also check the version through the SHOW VARIABLES query.
SHOW VARIABLES LIKE "%version%";
Here, we can check the MySQL version as well as other version-related attributes.
MySQL check version mac
There are different ways to check MySQL version on mac
To check the MySQL version on mac, we will go to the terminal and type the below query.
Once you log into MySQL through the mac terminal, the MySQL server version is displayed.
If you are inside MySQL prompt, then execute:
MySQL check version workbench
To check the MySQL server version from the workbench, go to the Administration tab.
We hope this article helped you to check the MySQL version. Good Luck !!!
Thanks for reading.