HowTo: Find Out MySQL Server Version Number

by

To find out the version of a MySQL server running on your system, you can use the following command in the MySQL command-line client:

SELECT VERSION();

Running this command in the MySQL command-line client will display the version number of the MySQL server that you are currently connected to.

For example, running this command might produce output like this:

+-----------+
| VERSION() |
+-----------+
| 8.0.27 |
+-----------+

This output shows that the MySQL server version is 8.0.27.

Alternatively, you can use the following command to display the version number of the MySQL server without connecting to the MySQL command-line client:

mysql --version

Running this command in a terminal will display the version number of the MySQL client and the MySQL server, for example:

mysql Ver 8.0.27-0ubuntu0.20.04.1 for Linux on x86_64 ((Ubuntu))

This output shows that the MySQL server version is 8.0.27.

(aaplumbingsa.com)

Leave a Comment