1 Use status in the command line to view.
mysql> status;
--------------
MySQL Ver 14.14 distrib 5.5.25a, for Linux (x86_64) using ReadLine 5.1
Connection id:33348
Current database:
Current User: [email protected]
Ssl:not in use
Current Pager:stdout
Using outfile: '
Using delimiter:;
Server Version:5.5.25a-log MySQL Community Server (GPL)
Protocol version:10
Connection:localhost via UNIX socket
Server characterset:latin1
Db characterset:latin1
Client Characterset:utf8
Conn. Characterset:utf8
UNIX Sockets:/var/lib/mysql/mysql.sock
Uptime:9 Days Hours min sec
Threads:14 questions:7724060 Slow queries:0 opens:532 Flush tables:1 Open tables:237 queries per second Avg:9 .064
--------------
2. Using System functions
Mysql> select version ();
+-------------+
| Version () |
+-------------+
| 5.5.25a-log |
+-------------+
1 row in Set (0.01 sec)
3. Using commands
MySQL--help | grep distrib
MySQL Ver 14.14 distrib 5.5.25a, for Linux (x86_64) using ReadLine 5.1
4. In the terminal use,
Mysql-v
MySQL Ver 14.14 distrib 5.5.25a, for Linux (x86_64) using ReadLine 5.1