Blogs![[Selected]](http://fplanque.com/img/down_small.gif){kind=small}
dev blog
| « About Apple Design | Easy web snapshots » |
What's my MySQL version number?
10/01/07
What's my MySQL version number?
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
3 comments
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
SELECT VERSION(); will work on mysql 3.23
Comment from: shahryar ghazi [Visitor]
here is a complete tutorial http://www.geeksww.com/tutorials/database_management_systems/mysql/tips_and_tricks/how_to_check_mysql_version_number.phpi guess u r only printing the client's version no. thru mysql -v
11/02/10 @ 14:43
Comment feed for this post
