Home >Database >Mysql Tutorial >How to verify whether mysql is installed successfully

How to verify whether mysql is installed successfully

coldplay.xixi
coldplay.xixiOriginal
2020-09-11 15:34:3813163browse

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.

How to verify whether mysql is installed successfully

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.

How to verify whether mysql is installed successfully

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

How to verify whether mysql is installed successfully

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.

How to verify whether mysql is installed successfully

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.

How to verify whether mysql is installed successfully

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn