Mysql remote connection error 1130

Source: Internet
Author: User

Mysql
Remotely connect to the Mysql server database. The ERROR code is 1130, ERROR 1130: Host xxx. xxx is not allowed to connect to this MySQL server
It is assumed that the remote connection User Permissions cannot be granted.
In this way, you can operate the mysql database.
 
After logging on to mysql on the local machine, change the "host" item in the "user" table in the "mysql" database and rename it '%' from "localhost ".
Mysql-u root-p
Mysql; use mysql;
Mysql; select 'host' from user where user = 'root ';
Mysql; update user set host = '%' where user = 'root ';
Mysql; flush privileges;
Mysql; select 'host' from user where user = 'root ';
 
 
 
First sentence: Log On with the root user of the permission
Second sentence: Select mysql database
Third sentence: view the host value of the user table in the mysql database (the host/IP name that can be accessed through connection)
Fourth sentence: Modify the host value (add host/IP address with the wildcard % content), of course, you can also directly add IP addresses
Fifth sentence: refresh the MySQL system permission table
The sixth statement is modified when you re-view the user table ..
Restart the mysql service.



By fireDragonpzy

Related Article

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.