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

Question

What command will return the present version of the MySQL database?

Answer 1

Several answers suggest using mysql --version. However, the mysql program is the client. The server is mysqld. Hence the command should be:

mysqld --version

That worked for me on Windows and Debian.

mysqld --help

While connected to the MySQL server with a client you can use.

select version()

or

select @@version

Want to become a SQL Expertise? Register to this SQL Course and get certified.