CentOS6.8 MySQL database version information view

Method 1: Use the MYSQL-V command to view:

[Email protected] mysql]# mysql-vmysql  Ver 14.14 distrib 5.1.73, for Redhat-linux-gnu (x86_64) using ReadLine 5.1[[e Mail protected] mysql]# mysql--versionmysql  Ver 14.14 distrib 5.1.73, for Redhat-linux-gnu (x86_64) using ReadLine 5. 1

Method 2: Check the contents of the MySQL--help command:

[[email protected] mysql]# MySQL--help | grep distribmysql  Ver 14.14 distrib 5.1.73, for Redhat-linux-gnu (x86_64) using ReadLine 5.1

Method 3: View the installation package version with the RPM command:

[Email protected] mysql]# Rpm-qa | grep mysqlmysql-5.1.73-8.el6_8.x86_64
Mysql-server-5.1.73-8.el6_8.x86_64

Method 4: When you log in to the database, you can see the version information corresponding to the MySQL database as follows:

Method 5:mysqladmin-uroot-p-hlocalhost Version command to view MySQL database versions:

Method 6: Use the system functions to view the MySQL database version:

Method 7: Use the status command to view:

Method 8:show variabes Command view:

CentOS6.8 MySQL database version information view