Host is not a allowed to connect to this MySQL server solution can access the local area network database! Perfect solution!

Source: Internet
Author: User

0.

http://blog.csdn.net/flyyhz/article/details/77100243

1.

2.

3.

4.

5.

6.

7.

8.

9.

Today on Linux installed MySQL, but found in the local login can, but remote login but error Host is not allowed to connect to this mysql server , find a half-day to try some of the online methods are not resolved, and finally found a solution in an article, deliberately recorded.

First of all, the error is that our MySQL is not allowed to Telnet, so telnet failed, the workaround is as follows:

      1. Log on to the MySQL mysql-u root-p password on the MySQL-equipped machine
      2. Performuse mysql;
      3. Execution update user set host = ‘%‘ where user = ‘root‘; of this sentence may be an error, do not care about it.
      4. PerformFLUSH PRIVILEGES;

        After 4 steps above, you can solve this problem.
        Note: The fourth step is to refresh the MySQL permissions related tables, must not forget, I did not perform the first time fourth step, the results have been unsuccessful, finally found this reason.

Host is not a allowed to connect to this MySQL server solution can access the local area network database! Perfect solution!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.