What's my MySQL version number?

10/01/07

04:44:56 pm, by Francois PLANQUE

, Categories: mySQL

In order to determine which MySQL version you're running you can type the following command: mysql -V

Sample results:

# mysql -V
mysql Ver 14.7 Distrib 4.1.11, for pc-linux-gnu (i386)

# mysql -V
mysql Ver 14.12 Distrib 5.0.32, for pc-linux-gnu (i486) using readline 5.2

Now, if you want to query for the version number while beign logged in (PHP script for example), just go with: SELECT VERSION(); .

I believe this is only working since MySQL 4 though.

Tags: mysql

Comment from: Andrew [Visitor]

Hi,

For all versions of mysql if you do SHOW VARIABLES; you will see the version in the list returned regardless of the version of mysql used.

10/11/07 @ 10:37

Weblog on development, technology, the Internet, databases, open-source, weblogs and presumably some geeky stuff too... :P