Tuesday, May 1, 2012

HowTo: Find Out MySQL Server Version Number

How do I find out mysql server version number under UNIX / Linux operating systems?

You can use the mysqladmin command to get version information from server as follows. Open terminal and type the following command (for remote server login over ssh session):
$ mysqladmin -u root -p version
Sample outputs:
Enter password:
mysqladmin Ver 8.41 Distrib 5.0.77, for redhat-linux-gnu on x86_64
Copyright (C) 2000-2006 MySQL AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 5.0.77
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 16 hours 37 min 50 sec
Threads: 2 Questions: 32558157 Slow queries: 0 Opens: 2992 Flush tables: 1 Open tables: 1684 Queries per second avg: 222.589


No comments:

Post a Comment