Mysql can use localhost for IP connection.

 

Today, I made a very low-level error: MySQL can be connected using localhost, but it cannot be connected using IP addresses.

 

 

 

The result is that you forgot to authorize the database. Use the grant command in the MySQL command line console.

 

 

 

Grant all privileges on *. * to 'username '@ 'IP address 'identified by 'Password ';

 

All privileges permissions can also be written as select, update, etc.

*. * All tables in all databases, such as databasename .*

User Name

IP address of the IP database

Identified by 'Password' indicates a password connection.

 

 

 

Run the following command to refresh the permission.

 

Flush privileges;

 

Author cooler1217