MySQL can be connected with localhost, but not IP-connected problem-solving method _mysql

MySQL localhost connection, but cannot use IP connectivity problem solution

Mainly related to MySQL can use localhost connection, but can not use IP connectivity issues, for MySQL can be connected with localhost, but can not use IP connection problem

1. Open the cmd window and enter the MySQL installed bin directory

2. Execute the command log in to the database, and then there will be a line to mysql-u you enter the password root-p

3. Execute the following command to assign a new user:
Grant all privileges in *.* to ' root ' @ '% ' identified by ' root '; (%) Represents all IP

4. Refresh permissions with the following command after executing the above command
Flush privileges;

5. Then shut down the MySQL service and start the MySQL service.

Thank you for reading, I hope to help you, thank you for your support for this site!