Determine the version of MySQL server

Contributor Icon Contributed by qmchenry Date Icon December 14, 2003  
Tag Icon Tagged: MySQL


To determine the version of the MySQL server running on host ‘elephant’ use:

mysql -h elephant -V
mysql Ver 12.21 Distrib 4.0.14, for pc-linux (i686)

The MySQL version indicated by the output line above is 4.0.14. To determine the version of MySQL running on the local host, use the same command without the ‘-h elephant’ option.

Previous recipe | Next recipe |
 
  • T Dog
    This doesn't work. The version displayed is the client, not the server. For proof, use -h foo and you get the same version.
blog comments powered by Disqus