How to retrieve the current version of a MySQL database management system (DBMS)?

Question

What command returns the current version of a MySQL database?

A surprising number of answers below suggest some variant of mysql --version. This gives the version of the client utility, not the server, so it's a bit like trying to find out your version of Apache by loading Firefox and opening the Help->About dialog. — mwfearnley
– mwfearnley, Commented Mar 6, 2019 at 16:44

Nolwennig · Accepted Answer · 2017-12-18 20:06:15Z

Try this function -

SELECT VERSION(); -> '5.7.22-standard'

VERSION()

Or for more details use :

SHOW VARIABLES LIKE "%version%"; +-------------------------+------------------------------------------+ | Variable_name | Value | +-------------------------+------------------------------------------+ | protocol_version | 10 | | version | 5.0.27-standard | | version_comment | MySQL Community Edition - Standard (GPL) | | version_compile_machine | i686 | | version_compile_os | pc-linux-gnu | +-------------------------+------------------------------------------+ 5 rows in set (0.04 sec)

MySQL 5.0 Reference Manual (pdf) - Determining Your Current MySQL Version - page 42

dev.mysql.com/doc/refman/5.0/en/installation-version.html is a 404.
what if I don't want to run anything related to mysql itself? where is this version information stored?
@Sajuuk it isn't stored anywhere. but if you are using some kind of packaging system, that will store the version
This is instant solution. I got it on first click. It should be the accepted answer.

Paul Spiegel · Accepted Answer · 2019-03-07 13:46:33Z

Many answers suggest to use mysql --version. But the mysql programm is the client. The server is mysqld. So the command should be

mysqld --version

or

mysqld --help

That works for me on Debian and Windows.

When connected to a MySQL server with a client you can use

select version()

or

select @@version

mysqld --version does not work on Windows 10's Command Prompt as of MySQL 8.0.41 when not connected to the local (same machine) database. The --help also does not work. 'mysqld' is not recognized as an internal or external command, operable program or batch file.

Michael Krelin - hacker · Accepted Answer · 2012-01-24 13:35:14Z

173

try

mysql --version

for instance. Or dpkg -l 'mysql-server*'.

answered Jan 24, 2012 at 13:35

Michael Krelin - hacker

144k25 gold badges200 silver badges177 bronze badges

9 Comments

user56reinstatemonica8 Over a year ago

This is the best quick option if you're lazy - you don't even need to log in :-D works fine on Centos / RHEL command line as well as Ubuntu.

Michael Krelin - hacker Over a year ago

@user568458, admittedly, though, it gives you the client's version or the version of local server provided that the one that is installed as a package is running ;)

Kellen Stuart Over a year ago

The command mysql --version is not OS specific. This will work on any Linux distro, Windows and OS X.

Michael Krelin - hacker Over a year ago

@KolobCanyon, well, unless you don't have it in path :)

mwfearnley Over a year ago

The command that works for the server version will presumably only work if the server is running from a Debian-installed package.

|

Amitesh Bharti · Accepted Answer · 2019-06-26 10:16:41Z

35

Mysql Client version : Please beware this doesn't returns server version, this gives mysql client utility version

mysql -version

Mysql server version : There are many ways to find

SELECT version();

SHOW VARIABLES LIKE "%version%";

mysqld --version

edited Jun 26, 2019 at 10:16

answered Aug 31, 2018 at 9:34

Amitesh Bharti

16k6 gold badges72 silver badges67 bronze badges

6 Comments

mwfearnley Over a year ago

The mysql command needs to be lower case for most non-Windows platforms. But also, it would be better not to open your answer with the MySQL client version, because it's not what's asked for, and could mislead people.

Amitesh Bharti Over a year ago

Idea here is to provide relevant information, not quick answer. Anyway, updated answer based on your suggestion. Thanks!!

mwfearnley Over a year ago

Hi, thanks for listening to my feedback. I would still remove the client info, because it’s not relevant (although it is tangentially related). And at the least I’d recommend opening with the “server version” info. Your warning is helpful though.

AmigoJack Over a year ago

Why a screenshot for what could have been easily copied as text?

Amitesh Bharti Over a year ago

It already has queries in the text format which is easy to copy.

|

Nolwennig · Accepted Answer · 2017-12-17 19:31:52Z

29

Use mysql -V works fine for me on Ubuntu.

edited Dec 17, 2017 at 19:31

Nolwennig

1,68424 silver badges30 bronze badges

answered Jun 6, 2016 at 1:57

Umesh Kaushik

1,6191 gold badge18 silver badges18 bronze badges

1 Comment

mwfearnley Over a year ago

This gives the version of the mysql client utility. This might be a similar version if it's installed on the same system as the server, but if they're on different systems, it could be completely different.

Nolwennig · Accepted Answer · 2017-12-18 17:37:41Z

SHOW VARIABLES LIKE "%version%"; +-------------------------+------------------------------------------+ | Variable_name | Value | +-------------------------+------------------------------------------+ | protocol_version | 10 | | version | 5.0.27-standard | | version_comment | MySQL Community Edition - Standard (GPL) | | version_compile_machine | i686 | | version_compile_os | pc-linux-gnu | +-------------------------+------------------------------------------+ 5 rows in set (0.04 sec)

MySQL 5.0 Reference Manual (pdf) - Determining Your Current MySQL Version - page 42

Sandun Susantha · Accepted Answer · 2020-11-03 11:06:56Z

Go to MySQL workbench and log to the server. There is a field called Server Status under MANAGEMENT. Click on Server Status and find out the version.

Or else go to following location and open cmd -> C:\Windows\System32\cmd.exe. Then hit the command -> mysql -V

Note that you get to the 'Management' window by clicking on 'Administration' (rather than 'Schemas') in the tabs at the bottom of the 'Navigator' window on the left.

tk_ · Accepted Answer · 2016-06-30 07:18:51Z

I found a easy way to get that.

Example: Unix command(this way you don't need 2 commands.),

$ mysql -u root -p -e 'SHOW VARIABLES LIKE "%version%";'

Sample outputs:

+-------------------------+-------------------------+ | Variable_name | Value | +-------------------------+-------------------------+ | innodb_version | 5.5.49 | | protocol_version | 10 | | slave_type_conversions | | | version | 5.5.49-0ubuntu0.14.04.1 | | version_comment | (Ubuntu) | | version_compile_machine | x86_64 | | version_compile_os | debian-linux-gnu | +-------------------------+-------------------------+

In above case mysql version is 5.5.49.

Please find this useful reference.

Nirojan Selvanathan · Accepted Answer · 2016-12-28 06:13:35Z

Simply login to the Mysql with

mysql -u root -p

Then type in this command

select @@version;

This will give the result as,

+-------------------------+ | @@version | +-------------------------+ | 5.7.16-0ubuntu0.16.04.1 | +-------------------------+ 1 row in set (0.00 sec)

Denim Datta · Accepted Answer · 2013-12-05 08:49:23Z

14

For UBUNTU you can try the following command to check mysql version :

mysql --version

edited Dec 5, 2013 at 8:49

Denim Datta

3,8124 gold badges30 silver badges53 bronze badges

answered Dec 5, 2013 at 8:30

Muhammad waqas muneer

2052 silver badges3 bronze badges

2 Comments

dani24 Over a year ago

This is the same response that @MichaelKrelin answered!

Matt K Over a year ago

This will give you the mysql client version, not the server.

Nanhe Kumar · Accepted Answer · 2020-03-03 14:10:22Z

13

MySQL Server version

shell> mysqld --version

MySQL Client version

shell> mysql --version shell> mysql -V

edited Mar 3, 2020 at 14:10

answered Jan 13, 2014 at 7:20

Nanhe Kumar

16.4k5 gold badges84 silver badges72 bronze badges

2 Comments

mwfearnley Over a year ago

These give the version of the mysql client utility, which may be completely different from the version the database server is running.

mwfearnley Over a year ago

I see you've updated your answer now to include both, and put the server version first. Thanks.

ptierno · Accepted Answer · 2014-11-01 02:49:19Z

9

mysqladmin version OR mysqladmin -V

edited Nov 1, 2014 at 2:49

ptierno

10.1k2 gold badges26 silver badges37 bronze badges

answered Oct 28, 2014 at 7:22

Singh Anuj

991 silver badge1 bronze badge

2 Comments

Amitesh Bharti Over a year ago

This will tell mysqladmin client version not to mysql server

mwfearnley Over a year ago

mysqladmin version (with appropriate connection details) will give the actual server version, but mysqladmin -V gives the version of the mysqladmin command-line utility, which is probably not what you want.

GDP · Accepted Answer · 2012-08-02 18:04:22Z

8

From the console you can try:

mysqladmin version -u USER -p PASSWD

edited Aug 2, 2012 at 18:04

GDP

8,1636 gold badges48 silver badges84 bronze badges

answered Jan 24, 2012 at 13:37

spike

894 bronze badges

1 Comment

David Aug 12 at 3:37

note that the command includes the password, which might be saved in the log-file for the shell (bash / cli / terminal emulator). To avoid this, enter the command with -p parameter but never add the password, you'll be prompted then to enter the password but it won't be saved in any log file.

KayV · Accepted Answer · 2018-08-09 07:39:27Z

8

For Mac,

login to mysql server.
execute the following command:
```
 SHOW VARIABLES LIKE "%version%"; 
```

answered Aug 9, 2018 at 7:39

KayV

14k17 gold badges106 silver badges156 bronze badges

2 Comments

mwfearnley Over a year ago

This should work in a MySQL client on any platform. It's the same solution given in an earlier answer: stackoverflow.com/a/8987742/446106

Codigo Morsa Over a year ago

This worked for me from Datagrip, and as mentioned earlier, should work from any mysql client, because it is a db query, it is not os dependant so far I understand.

Nolwennig · Accepted Answer · 2017-04-11 14:39:33Z

With CLI in one line :

mysql --user=root --password=pass --host=localhost db_name --execute='select version()';

or

mysql -uroot -ppass -hlocalhost db_name -e 'select version()';

return something like this :

+-----------+ | version() | +-----------+ | 5.6.34 | +-----------+

note that the 2nd command includes the password, which might be saved in the log-file for the shell (bash / cli / terminal emulator). To avoid this, enter the command with -p parameter but never add the password, you'll be prompted then to enter the password but it won't be saved in any log file.

David Duggins · Accepted Answer · 2016-12-23 20:24:58Z

You can also look at the top of the MySQL shell when you first log in. It actually shows the version right there.

Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 67971 Server version: 5.1.73 Source distribution Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql>

Marco Bonelli · Accepted Answer · 2017-04-19 10:16:28Z

E:\>mysql -u root -p Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1026 Server version: 5.6.34-log MySQL Community Server (GPL) Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select @@version; +------------+ | @@version | +------------+ | 5.6.34-log | +------------+ 1 row in set (0.00 sec)

Could you please provide some context to your answer. Though its clear this shows a solution, some explanation as to your approach and why its a good method would be helpful. Generally just posting code chunks is frowned on in SO.
I don't think any explanation is needed for why SELECT @@version;, which shows the version, would be a good method for showing the version. The bigger issue IMO is that this answer is a duplicate of earlier answers.

Romeo · Accepted Answer · 2024-02-21 14:48:11Z

3

Xampp with Windows users below in the command which worked in the MySQL directory.

edited Feb 21, 2024 at 14:48

Romeo

1171 gold badge2 silver badges11 bronze badges

answered Apr 19, 2021 at 6:50

Amol Bhandari SJ

2782 silver badges15 bronze badges

Comments

Chaminda Bandara · Accepted Answer · 2019-05-29 20:45:37Z

0

In windows ,open Command Prompt and type MySQL -V or MySQL --version. If you use Linux get terminal and type MySQL -v

edited May 29, 2019 at 20:45

Chaminda Bandara

2,1883 gold badges28 silver badges31 bronze badges

answered Aug 18, 2018 at 15:23

Manjitha Teshara

6022 gold badges9 silver badges22 bronze badges

2 Comments

pheromix Over a year ago

quick ! no need to be connected to the database :) thanks

mwfearnley Over a year ago

This is only for the MySQL client, which may be very different from the sever. Also, the Linux command would need to be lower case.

Dibyendu Mitra Roy · Accepted Answer · 2022-05-07 21:02:38Z

Sometimes it is important to know which version of MySQL candidate is available to installed by default. here is the little command to check that prior to actually installing.

sudo apt-cache policy mysql-server

This is more important for any existing project which might be running on old MySQL Versions e.g. 5.7.

A sample output of the above command could be:

mysql-server: Installed: (none) Candidate: 8.0.29-0ubuntu0.20.04.3 Version table: 8.0.29-0ubuntu0.20.04.3 500

500 http://mirrors.digitalocean.com/ubuntu focal-updates/main amd64 Packages 500 http://security.ubuntu.com/ubuntu focal-security/main amd64 Packages 8.0.19-0ubuntu5 500

500 http://mirrors.digitalocean.com/ubuntu focal/main amd64 Packages

This states that by default by running the following command some flavour of MySQL Server 8 will be installed.

sudo apt install mysql-server

F1Linux · Accepted Answer · 2022-07-28 00:10:03Z

Print a Dockerized MariaDB/MySQL Server version:

When I backup a WordPress site- in this case containerized- I capture the WordPress version in the filename as well as the DB version that was current at the time of the backup. This ensures that if I ever needed to restore, I wouldn't have a compatibility nightmare figuring out what version DB works with a specified version of the WordPress backup.

So I include the DB server version in the dump name. I loaded the below into a self-populating variable:

docker exec -it ContainerIdOfDB mysqld --version | awk '{print $3}' | cut -d'-' -f1

This pukes out the current DB version without having to login to retrieve it.

John Elvial · Accepted Answer · 2019-03-10 10:32:38Z

Here two more methods:

Linux: Mysql view version: from PHP

From a PHP function, we can see the version used:

mysql_get_server_info ([resource $ link_identifier = NULL]): string

Linux: Mysql view version: Package version

For RedHat / CentOS operating systems:

rpm -qa | grep mysql

For Debian / Ubuntu operating systems:

rpm -qa | grep mysql

Extracted from: https://www.sysadmit.com/2019/03/linux-mysql-ver-version.html

Kuhan · Accepted Answer · 2019-11-16 04:25:19Z

-1

Only this code works for me

/usr/local/mysql/bin/mysql -V

answered Nov 16, 2019 at 4:25

Kuhan

60311 silver badges22 bronze badges

1 Comment

Nico Haase Over a year ago

That returns the version number of the client, not of the server

Collectives™ on Stack Overflow

How to retrieve the current version of a MySQL database management system (DBMS)?

23 Answers 23

4 Comments

2 Comments

9 Comments

6 Comments

1 Comment

Comments

1 Comment

Comments

Comments

2 Comments

2 Comments

2 Comments

1 Comment

2 Comments

1 Comment

Comments

2 Comments

Comments

2 Comments

Comments

Print a Dockerized MariaDB/MySQL Server version:

Comments

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

23 Answers 23

4 Comments

2 Comments

9 Comments

6 Comments

1 Comment

Comments

1 Comment

Comments

Comments

2 Comments

2 Comments

2 Comments

1 Comment

2 Comments

1 Comment

Comments

2 Comments

Comments

2 Comments

Comments

Print a Dockerized MariaDB/MySQL Server version:

Comments

Comments

1 Comment

Linked

Related