MySQL does not enable remote access control by default.

MySQL does not enable remote access control by default.

 

1. Create a remote user accountLog On with the root user, and then: 1. Grant all privileges on *. * to the created username @'%'Identified by "password"; 2. Flush privileges; // The user authorization created above must be refreshed; otherwise, the authorization is invalid.

 

Format:Grant permission on database name. Table name to user @ login host identified by "User Password ";Note: @The IP address (or host name) of the client accessing MySQL)%Represents any client. If localhost is set to local access.

Example:

Grant all privileges on *. * To Mirze @ '%' identified by '123 ';

Flush privileges;

 

2. Set remote access permissions for existing users: 1. Use MySQL; 2. update user set host = '%' where user = 'username ';

3. Flush privileges;

 

Note: For remote access, you must open the port used by the MySQL server.