How to check the number of mysql

How to check the number of mysql: First open cmd; then switch to the bin directory of mysql; finally execute the command "e:\mysql\bin>mysql -V".

Recommended: "mysql video tutorial"

To check the MySQL version, there are mainly the following methods:

I want to check the MySQL version without connecting to the MySQL server. Open cmd, switch to the bin directory of mysql, and run the following command:

e:\mysql\bin>mysql -V
mysql  Ver 14.14 Distrib 5.6.32, for Win32 (AMD64)

(version 5.6.32)

or:

e:\mysql\bin>mysql -v

This command can be viewed to get more detailed information, because it will use the account ODBC to connect to the MySQL server and connect to port 3306 on localhost by default.

Or:

e:\mysql\bin>mysql --help | find "Distrib"
mysql  Ver 14.14 Distrib 5.6.32, for Win32 (AMD64)

This method is only available under Windows system, because Windows only uses the find command to find strings, and the following strings must be wrapped in double quotes, while Linux Although | is also used as the pipe character in the system, the grep command is used to find strings (such as: mysql --help | grep Distrib).

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