Determine the version of MySQL server

Home -> Database -> MySQL

20489 views

From the computer of: qmchenry (339 recipes)
Created: Dec 14, 2003


Add a comment

Add to:
Add to stumbleuponAdd to del.icio.usDigg itAdd to FURL

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.

Subscribe to the Tech-Recipes Newsletter

You can get tips like this delivered in your email every week!

Enter your Email

We will never, ever sell your email address or spam you.





Related recipes:

  Connect to a MySQL server using the mysql command
  Display a list of databases on a MySQL server
  Solve: Can't connect to local MySQL server through socket /tmp/mysql.sock
  Create a MySQL database
  Describe the column structure of a MySQL table
  Select a MySQL database to use
  Drop or delete a table in MySQL
  Save MySQL query results into a text or CSV file
  Create a MySQL user account
  Import CSV file directly into MySQL

 

Sponsored links

 

Affiliated Sites


Certification Journals
Free certification exam study guides and help

Tech-Recipes Blogs
More tips and news from the tech-recipes authors

 

Login

Nickname

Password

Don't have an account yet? You can create one. As a registered user you have some advantages like theme manager, comments configuration and post comments with your name.