Home page   WebCheatSheet.com


Determine MYSQL Version From the Command Line


Determining MySQL version is not very difficult but the command line is a quick trick and its useful. Once you are logged in to the server issue mysql -h localhost -V command:

C:\xampp\mysql\bin>mysql -h localhost -V
C:\xampp\mysql\bin\mysql.EXE  Ver 14.14 Distrib 5.1.41, for Win32 (ia32)

Another option is to logon to MySQL and run SHOW VARIABLES LIKE 'version'; query:

mysql> SHOW VARIABLES LIKE 'version';
+---------------+------------+
| Variable_name | Value      |
+---------------+------------+
| version       | 5.0.90-log |
+---------------+------------+
1 row in set


Copyright © 2005-2007 www.WebCheatSheet.com All Rights Reserved.