30
Nov

Learn how to find out what version of MySQL running?

By admin|Computer, MySQL

Apart from giving the ‘Server version’, this command also displays the current status of the mysql server.

mysqladmin -u root -p version
Enter password: 
/Applications/MAMP/Library/bin/mysqladmin  Ver 8.42 Distrib 5.5.9, for osx10.6 on i386
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version		5.5.9
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/Applications/MAMP/tmp/mysql/mysql.sock
Uptime:			4 min 43 sec

Threads: 1  Questions: 28  Slow queries: 0  Opens: 48  Flush tables: 1  Open tables: 41  Queries per second avg: 0.98
Tagged as: ,