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.
Method1:
select version();
Output:-
Method2:
Similarly, we can also use:
Frequently Asked:
- MySQL add primary key multiple columns
- MySQL Update with Inner Join
- MySQL- Drop/ Delete column from table
- SELECT 1 FROM TABLE
select @@version;
Output:-
Method3:
We can also check the version through the SHOW VARIABLES query.
SHOW VARIABLES LIKE "%version%";
Output:-
![](https://thispointer.com/wp-content/uploads/2021/05/Screenshot-2021-05-22-at-8.37.50-PM-1.jpg)
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
Method1:
To check the MySQL version on mac, we will go to the terminal and type the below query.
mysql -V
Output:-
![](https://thispointer.com/wp-content/uploads/2021/05/Screenshot-2021-05-22-at-9.30.56-PM-1024x348.jpg)
Method2:
Once you log into MySQL through the mac terminal, the MySQL server version is displayed.
![](https://thispointer.com/wp-content/uploads/2021/05/Screenshot-2021-05-22-at-9.36.17-PM-1024x429.jpg)
Method3:
If you are inside MySQL prompt, then execute:
mysql> status
Output:-
![](https://thispointer.com/wp-content/uploads/2021/05/Screenshot-2021-05-22-at-9.45.09-PM-1024x506.jpg)
MySQL check version workbench
To check the MySQL server version from the workbench, go to the Administration tab.
![](https://thispointer.com/wp-content/uploads/2021/05/Screenshot-2021-05-22-at-9.56.09-PM-1024x369.jpg)
We hope this article helped you to check the MySQL version. Good Luck !!!