{"id":12782,"date":"2023-12-09T08:24:44","date_gmt":"2023-12-09T15:24:44","guid":{"rendered":"https:\/\/www.mysqltutorial.org\/?page_id=12782"},"modified":"2023-12-09T08:28:41","modified_gmt":"2023-12-09T15:28:41","slug":"show-mysql-version","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-administration\/show-mysql-version\/","title":{"rendered":"How to Show the MySQL Version"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to show the MySQL version of the server you’re using.<\/p>\n\n\n\n

Showing MySQL version using the version system variable<\/h2>\n\n\n\n

When working with MySQL, it’s important to know the version of the server that you’re using. The @@version<\/code> variable provides you with a quick and easy way to obtain this information.<\/p>\n\n\n\n

Step 1. Connect to MySQL Server<\/h3>\n\n\n\n

Let’s start by connecting to your MySQL server<\/a> using the command-line client or GUI tool like MySQL Workbench.<\/p>\n\n\n\n

If you use a command-line client like mysql program, you can use the following command to connect to the MySQL server:<\/p>\n\n\n

mysql -u your_username -p<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
You need to replace your_username<\/code> with your MySQL username and enter your password when prompted.<\/p>\n\n\n\n
Step 2: Use @@version to Show MySQL Version<\/h3>\n\n\n\n
Once connected, you can execute the following SQL query to display the MySQL version:<\/p>\n\n\n
SELECT<\/span> @@version<\/span> AS<\/span> 'MySQL Version'<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
This query provides a concise output containing your MySQL server version, including version number and additional details. For example:<\/p>\n\n\n
+---------------+<\/span>\n| MySQL Version |\n+---------------+<\/span>\n| 8.0.34        |\n+---------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Showing MySQL version using mysql<\/h2>\n\n\n\n
Another way to show the MySQL version is to use the mysql command line with the –version option.<\/p>\n\n\n\n
First, open the Command Prompt on Windows or Terminal on macOS and Linux.<\/p>\n\n\n\n
Second, use the mysql<\/code> command with the -V<\/code> option<\/p>\n\n\n
mysql -V<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
It’ll return the MySQL version of the server:<\/p>\n\n\n
C:\\Program Files\\MySQL\\MySQL Server 8.0\\bin\\mysql.exe  Ver 8.0.34 for Win64 on x86_64 (MySQL Community Server - GPL)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Getting the MySQL version using the version() function<\/h2>\n\n\n\n
If you want to use the version of MySQL in a query, you can use the version()<\/code> function.<\/p>\n\n\n\n
The following statement uses the version()<\/code> function to get the version of the MySQL server:<\/p>\n\n\n
SELECT<\/span> version<\/span>();<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+-----------+<\/span>\n| version() |\n+-----------+<\/span>\n| 8.0.34    |\n+-----------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
For example, you can use the version()<\/code> function with the CONCAT_WS()<\/code> function:<\/p>\n\n\n
SELECT<\/span> \n  CONCAT<\/span>(\n    'MySQL'<\/span>, \n    ' '<\/span>, \n    VERSION<\/span>()\n  ) version<\/span>;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
+--------------+<\/span>\n| version      |\n+--------------+<\/span>\n| MySQL 8.0.34 |\n+--------------+<\/span>\n1 row in set<\/span> (0.00<\/span> sec)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Summary<\/h2>\n\n\n\n
    \n
  • Use the @@version<\/code> system variable or mysql --version<\/code> command to show the MySQL version of the server.<\/li>\n<\/ul>\n
    \n\t
    \n\t\t
    Was this tutorial helpful? <\/div>\n\t\t
    \n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t\n\t\t\t\t\t<\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t
    \n\t\t
    \n\t\t\t
    <\/div>\n\t\t\t\n\t\t\t