View MySQL database version method summary!

Objective:

when you take over a MySQL database management, first you need to view the version of the MySQL database that is maintained, or When the developer asks you the MySQL database version, and you forget it, you also need to look at the MySQL database version. These are my own collection, share to everyone!

1. If you are Yum installed

Rpm-qa|grep MySQL or rpm-qa|grep-i MySQL

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M01/83/1F/wKioL1dra7zB56znAAApWXa3mMc267.png-wh_500x0-wm_3 -wmp_4-s_1110415248.png "title=" 10.png "alt=" Wkiol1dra7zb56znaaapwxa3mmc267.png-wh_50 "/>

Mysql-server-5.1.73-3.el6_5.x86_64

If you can log into the database

2. View when landing

Mysql-u root-p

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M00/83/1F/wKiom1drbEiynK08AABlaWF4vI8660.png-wh_500x0-wm_3 -wmp_4-s_3367767613.png "title=" 10.png "alt=" Wkiom1drbeiynk08aablawf4vi8660.png-wh_50 "/>

3. mysql> Select version ();

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M01/83/1F/wKioL1drbL7Tkf4JAAAdZSx5dBQ067.png-wh_500x0-wm_3 -wmp_4-s_120119961.png "title=" 10.png "alt=" Wkiol1drbl7tkf4jaaadzsx5dbq067.png-wh_50 "/>

4, mysql> status;

650) this.width=650; "Src=" Http://s3.51cto.com/wyfs02/M00/83/1F/wKiom1drbQaB8mtDAACVeR78g1I691.png-wh_500x0-wm_3 -wmp_4-s_374890718.png "title=" 10.png "alt=" Wkiom1drbqab8mtdaacver78g1i691.png-wh_50 "/>

5, SHOW VARIABLES like "%version%";

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M02/83/1F/wKiom1drbTnRuYH9AABFChSciBk816.png-wh_500x0-wm_3 -wmp_4-s_616302683.png "title=" 10.png "alt=" Wkiom1drbtnruyh9aabfchscibk816.png-wh_50 "/>

View without logging in

6, Mysql-v

650) this.width=650; "Src=" Http://s1.51cto.com/wyfs02/M02/83/1F/wKioL1drbhfRlbIHAAAd8xQgTbE362.png-wh_500x0-wm_3 -wmp_4-s_3500065491.png "title=" 10.png "alt=" Wkiol1drbhfrlbihaaad8xqgtbe362.png-wh_50 "/>

Ver 14.14 Distrib 5.1.73,

7. mysql--help or mysql--help | grep distrib

650) this.width=650; "Src=" Http://s5.51cto.com/wyfs02/M02/83/1F/wKiom1drboWRygS4AABDRBZO8Cg652.png-wh_500x0-wm_3 -wmp_4-s_3631930851.png "title=" 10.png "alt=" Wkiom1drbowrygs4aabdrbzo8cg652.png-wh_50 "/>

8. mysql--version

650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/83/1F/wKioL1drbuaAhhMsAAAeL6HyUR0303.png-wh_500x0-wm_3 -wmp_4-s_2300652544.png "title=" 10.png "alt=" Wkiol1drbuaahhmsaaael6hyur0303.png-wh_50 "/>

9, if it is compiled or binary installation

CD xx/mysql (MySQL installation directory)/bin

./mysql--version can

Write a blog, check your own convenience. Is the way different only, oneself with oneself handy of can!

This article is from the "Ningzhiyuan ~it sharing" blog, make sure to keep this source http://renzhiyuan.blog.51cto.com/10433137/1792148

View MySQL database version method summary!