MySQL cannot link remote, reported (Host ' ***.***.***.*** ' is not allowed to connect to this MySQL server)

Host ' ***.***.***.*** ' isn't allowed to connect to this MySQL server

WHERE * * * ... is the local public network IP;

Workaround:

2. Reading the wrong window first.

4. The error is due to the fact that the local IP (xxx.xxx.xxx.xxx) does not have permission to access the remote database .

   The following enables local IP (xxx.xxx.xxx.xxx) access to the remote MySQL database.

6. First, the remote connection enters the server, enters the mysql-u root-pin the CMS, then returns, enters the password, enters the MySQL command line.

8. Input use MySQL;

10. Enter select user,password,host from user;

    You can see that there is only localhost in host. We need to add xxx.xxx.xxx.xxx to this.

12. Add the following method:

    Input

    Grant all privileges on * * to [e-mail protected] "xxx.xxx.xxx.xxx" identified by "password";

    This is equivalent to giving ip-xxx.xxx.xxx.xxx all the permissions, including remote access permissions.

    And then enter

    Flush privileges;

    This is equivalent to reloading MySQL permissions, which must be there .

14. Re-enter select User,password,host from user;

    You can see that the new IP has been added to the host.

16. Now again with Navicat for MySQL access to the remote MySQL database, has been able to open the normal.

    Problem solving.

18. However, there is another problem, found that the double-click to open a table is very slow, at least 3 seconds.

    The reasons are:

    When MySQL is accessed remotely, MySQL resolves the domain name, which results in slow access, 2, 3 seconds delay!

    Workaround:

    Modify the My.ini in the MySQL installation directory, and add the following configuration to resolve this issue. Join under [mysqld]:skip-name-resolve

    Save to restart the MySQL service after exiting.

    Then the access speed is as fast as the local.

MySQL cannot link to remote, reported (Host ' ***.***.***.*** ' is not allowed to connect to this MySQL server)