To determine the version and release of your currently installed MySQL installation, there are a number of options.
For example, here is the output from a MySQL Community Server edition installed on Linux:

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 6
Server version: 5.0.27-standard MySQL Community Edition - Standard (GPL)
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

You may also determine the version information using the version variables. Both the version and version_comment variables
contain version information for the server to which you are connected. Use the SHOW VARIABLES statement to obtain the information
you want, as shown in this example:

mysql> SHOW VARIABLES LIKE "%version%";
| Variable_name | Value |
| protocol_version | 10 |
| version | 5.0.27-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | i686 |
| version_compile_os | pc-linux-gnu |
5 rows in set (0.04 sec)

The STATUS command displays the version as well as version comment information. For example:

mysql> STATUS;
./client/mysql Ver 14.12 Distrib 5.0.29, for pc-linux-gnu (i686) using readline 5.0
Connection id: 8
Current database:
Current user: mc@localhost
SSL: Not in use
Current pager: /usr/bin/less
Using outfile: ''
Using delimiter: ;
Server version: 5.0.27-standard MySQL Community Edition - Standard (GPL)
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /tmp/mysql.sock
Uptime: 1 day 3 hours 58 min 43 sec
Threads: 2 Questions: 17 Slow queries: 0 Opens: 11 Flush tables: 1 Open tables: 6 Queries per second avg: 0.000

Post By Editor (2,827 Posts)

Website: →