Home  >  Article  >  Database  >  Remote MySQL database cannot access settings

Remote MySQL database cannot access settings

黄舟
黄舟Original
2017-08-03 11:21:461570browse

If the MySQL database server and the WEB server are not on the same machine, after installing MySQL, you need to make further settings to release the access rights to the MySQL database before you can access it.

1. First check the network environment. First, check whether the firewall is turned off. Second, check whether the network is smooth. Open the start menu-->Run, enter cmd, enter ping in the pop-up box and add on the IP address. If the network is unavailable, a timeout will appear, as shown in the figure

Remote MySQL database cannot access settings

2. If the network is open, a timeout will appear. Time information, as shown in the figure:

Remote MySQL database cannot access settings

3. Open MySQL Workbench and click on the blue area.

Remote MySQL database cannot access settings

4. Enter the root user password and log in.

Remote MySQL database cannot access settings

5. After opening, select the configuration corresponding to the root user in the red box as shown.

Remote MySQL database cannot access settings

6. Set the access permission corresponding to root to %, that is, all users can access. Then click Apply.

Remote MySQL database cannot access settings


The above is the detailed content of Remote MySQL database cannot access settings. 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