Home page
 
 Home 
 ASP 
 PHP 
 SQL 
 HTML 
 JavaScript 
 Search 
 Contact 
 
Search
or browse popular tags
Subscription

Sign up for the free email newsletter for new tips, tutorials and more. Enter your email address below, and then click the button.

Privacy Policy

RSS Twitter

Determine MYSQL Version From the Command Line

Print

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



Tags:

Add To: Add to dzone dzone | Digg this digg | Add to del.icio.us del.icio.us | Stumble it stumbleupon

  • Comments





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