How to get MySQL version

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:

select @@version;

Output:-

Method3:

We can also check the version through the SHOW VARIABLES query.

SHOW VARIABLES LIKE "%version%";

Output:-

Here, we can check the MySQL version as well as other version-related attributes.

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:-

Method2:

Once you log into MySQL through the mac terminal, the MySQL server version is displayed.

Method3:

If you are inside MySQL prompt, then execute:

mysql> status

Output:-

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 !!!