How to verify whether mysql is installed successfully

Mysql method to verify whether the installation is successful: 1. Open the DOS window and enter the status command to view the MySQL version information; 2. Open the MySQL 5.7 Command Line Client program, open the current MySQL server status, and enter the relevant commands to display the current database list.

Related learning recommendations: mysql tutorial

mysql Verify whether the installation is successful Method:

1. DOS window verification

Step 1): Open the DOS window. If you have configured the MySQL environment variable, log in directly; if there is no configuration To use environment variables, you need to log in to the mysql/bin directory. as the picture shows.

Step 2): Enter the status command to view the MySQL version information, as shown in the figure.

The above code indicates that the installation is successful.

2. MySQL client verification

Step 1): Open the MySQL 5.7 Command Line Client program, enter the password and press Enter, the current MySQL server status will pop up ,as the picture shows.

The current MySQL server version is 5.7.20-log MySQL Community Server (GPL), indicating that MySQL has been installed successfully.

Step 2): Enter a simple command in the MySQL 5.7 Command Line Client program, such as SHOW DATABASES; to display the current database list, as shown in the figure.

If the database list is displayed, the MySQL database is installed successfully.

If you want to know more about programming learning, please pay attention to the php training column!

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