MySQL database set remote connection permissions

Original

Problem phenomenon

MySQL installation is complete, the local login is normal, enter the correct account password remote login connection times wrong as follows

Cause of the problem

Remote IP does not have login rights, the root user can only be in localhost, only in the local login, you need to set allow other IP logon rights.

Solution Solutions

1. Log in to the database inside the server, and then execute

This statement means that the root user can log in to the database at any IP and manipulate any object in any database.

which

* * The first * refers to a database

* Represents all databases

The second * refers to a database object

* represents all objects in the database

' Root ' @ '% ' root is the database user who is making the authorization

% for allowed IP login

123456 is your database password.

If you want to limit only in 1.1.1.1 login, the% changed to 1.1.1.1, executed after the implementation of flush privileges; Refresh Permissions

2. Then the MySQL client on the remote computer can connect.

MySQL database set remote connection permissions