Tip: How To Find MySQL Version

By Angsuman Chakraborty, Gaea News Network
Saturday, September 1, 2007

Try:
mysql -e status|grep ‘Server version’

If that doesn’t work then use:
mysql -u root -p -e status|grep ‘Server version’
Provide root password when prompted. Default root password for MySQL is empty string, so just pressing enter when prompted for password will suffice by default.

Windows users should simply run:
mysql -e status
or the equivalent with login specified and then look for Server version string in the output to find the version.

Filed under: Database, How To, Linux, MySQL, RDBMS, Web, Windows
Discussion
February 15, 2010: 5:57 am

select version(); -> 5.0.67-0ubuntu6
works fine for me.


subrata bhattacharyya
February 13, 2010: 5:34 am

pl tell me clearly that how i can pay my tata bill through PNB ATM CARD

October 18, 2009: 10:24 am

If you’re logged in mysql try this:
select VERSION();

David Lyons
Pàgines web, aplicacions i xarxes informàtiques
https://www.ehtu.com

September 1, 2007: 9:13 am

i am doing select version(); which gives me the version from sql ?

YOUR VIEW POINT
NAME : (REQUIRED)
MAIL : (REQUIRED)
will not be displayed
WEBSITE : (OPTIONAL)
YOUR
COMMENT :