Mysql - How to find mysql version, Command for Mysql version Lookup

How to find mysql version

How do I find Mysql version Linux

Mysql version can found by multiple ways, if you are an admin you can lookup mysql version by using mysqladmin command

#  mysqladmin version

The above command will print the mysql version, which can be used to used to mysql version. The output will look as follows. You can lookup the mysql server version as 5.0.67

Output for mysql version lookup

mysqladmin  Ver 8.41 Distrib 5.0.67, for redhat-linux-gnu 
on i386 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.67
Protocol version	10
Connection		Localhost via UNIX socket
UNIX socket		/var/lib/mysql/mysql.sock
Uptime:			50 sec

Threads: 1  Questions: 2  Slow queries: 0  Opens: 12  
Flush tables: 1  Open tables: 6  Queries per second avg: 0.040

If your are able to run mysqladmin command then you can find the mysql version by using the mysqladmin command.

Mysql version lookup using shell

# mysql -e status | grep 'Server version'

The other method to find the mysql version is by using the above command

Output for mysql version lookup:

Server version:	     5.0.67 Source distribution

You can use the above command even if you are not an root user or a admin. can grep Mysql server version from mysql status.

Find mysql version & Path for socket

mysql -e status

The mysql status will return the detail's of mysql version, mysql socket, mysql iser e.t.c.

Output:

mysql  Ver 14.12 Distrib 5.0.67, for 
redhat-linux-gnu (i386) using readline 5.1

Connection id:		6
Current database:	
Current user:		ramesh@localhost
SSL:			Not in use
Current pager:		stdout
Using outfile:		''
Using delimiter:	;
Server version:	        5.0.67 Source distribution
Protocol version:	10
Connection:		Localhost via UNIX socket
Server characterset:	latin1
Db     characterset:	latin1
Client characterset:	latin1
Conn.  characterset:	latin1
UNIX socket:		/var/lib/mysql/mysql.sock
Uptime:			23 min 1 sec

Threads: 1  Questions: 25  Slow queries: 0  Opens: 12 
Flush tables: 1  Open tables: 6  Queries per second avg: 0.018
--------------

The topic on Mysql - How to find mysql version is posted by - Brangi

Hope you have enjoyed, Mysql - How to find mysql versionThanks for your time