Check out the summary of MySQL database version methods!

Foreword:

When you take over a mysql database management, you first need to check the maintained version of the mysql database, or when the developer asks you about the version of the mysql database, and you happen to forget, then you also need to check the version of the mysql database. These are collected by myself and shared with you!

1. If you are a yum installation

Rpm-qa | grep mysql or rpm-qa | grep-I mysql

Mysql-server-5.1.73-3.el6_5.x86_64

If you can log into the database,

2. Check when logging in.

Mysql-u root-p

3. Mysql > select version ()

4. Mysql > status

5. SHOW VARIABLES LIKE "% version%"

View without logging in

6. Mysql-V

Ver 14.14 Distrib 5.1.73

7. Mysql-- help or mysql-- help | grep Distrib

8. Mysql-version

9. If it is a compiler or a binary installation

Cd xx/mysql (MySQL installation directory) / bin

. / mysql-- version is fine

Write a blog and check it out for yourself. It's just that the way is different, you can use your own handy!