How to check database version

CheckSee the Mysql database version

1. Use Terminal

1. The parameter is -V (capital letters) or --version

Usage:

D:\mysql\bin>mysql -V

or

D:\mysql\bin>mysql --version

Disadvantages can only be executed on the server where Mysql is installed

2. MySQL client command: status (abbreviated as \s)

The status (\s) command is the simplest, but it can only Execute

3 in the MySQL Command Line Client. Use the terminal command to log in to mysql –u root –p. The login log also contains the version number

Disadvantages require reconnection Login

4. Enter rpm -qa | grep mysql
in the terminal. This is used to check the version number of the mysql installation package. In fact, it is useless to see the version number of the installation package.

2. SQL command

1. Use MySQL function: select version();

2. Use MySQL variables :show variables like '%version%'

3. Use the MySQL function: select version();

is the most common and can be used in the MySQL command line client and various graphical clients. Execution

Recommendation: "MySQL Tutorial"

The above is the detailed content of How to check database version. For more information, please follow other related articles on the PHP Chinese website!