What are the methods for mysql to verify whether the installation is successful?

Editor to share with you the methods of mysql to verify whether the installation is successful, I believe most people do not know much about it, so share this article for your reference, I hope you will learn a lot after reading this article, let's go to know it!

Mysql to verify whether the installation is successful: 1, open the DOS window, 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, enter relevant commands to display the current database list.

Mysql verifies that the installation is successful:

1. DOS window verification

Step 1): open the DOS window and log in directly if you have configured the MySQL environment variable; if you do not configure the environment variable, you need to log in to the mysql/bin directory. As shown in the figure.

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

The above code indicates that the installation is successful.

II. MySQL client verification

Step 1): open the MySQL 5.7Command Line Client program, enter the password and press enter to pop up the server status of the current MySQL, as shown in the figure.

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

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

If a list of databases is displayed, the MySQL database is installed successfully.

The above are all the contents of mysql's method to verify whether the installation is successful or not. Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!