Latest Post

Error: No input file specified.

While trying to run a codeigniter app the other day I came across this error just after I had finished uploading the files and making the ne...

Saturday, January 2, 2016

HOWTO: Determining Your Current MySQL Version

To determine the version and release of your currently installed MySQL installation, there are a number of options:

1) Using a command client (mysql), the server version of the MySQL server to which you are connected is shown once you are connected

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.


2) You may also determine the version information using the version variables, version and version_comment.
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)
3) You can also use the STATUS command which 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

Hope this helps someone

Chitika Ads