Error tips
The error code is 1130,error 1130:host 10.0.0.1 are not allowed to connect to this MySQL server
Solutions
Problem with user permissions for remote connection cannot be given.
The results of this operation of the MySQL library, you can solve.
After you log in to MySQL, change the "host" entry in the "User" table in the MySQL database, from "localhost" to "%".
The code is as follows |
Copy Code |
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 '; |
Some other way.
Method One, local login mysql, change "MySQL" Database in the "User" table in the "host" item, "localhost" changed to "%"
The code is as follows |
Copy Code |
#mysql-U root-proot Mysql>use MySQL; Mysql>update User Set host = '% ' where user = ' root '; Mysql>select host, user from user; |
Method II, direct authorization (recommended)
Use root from any host, password: youpassword (your root password) to connect to the MySQL server:
The code is as follows |
Copy Code |
# mysql-u Root-proot Mysql>grant all privileges in *.* to ' root ' @ '% ' identified by ' Youpassword ' with GRANT OPTION; |
Allow the address 202.11.10.253 to use root, password dboomysql to connect all the MySQL database, pay Select,insert,update,delete permissions.
The code is as follows |
Copy Code |
# mysql-u Root-proot Grant Select,insert,update,delete on *.* to root@ ' 202.11.10.253″identified by ' dboomysql '; |
Allow the address 202.11.10.253 to use root, password dboomysql to connect all the MySQL database, pay all the permissions.
The code is as follows |
Copy Code |
# mysql-u Root-proot Grant all on *.* to root@ ' 202.11.10.253″identified by ' dboomysql ' |
After restarting the MySQL service, you can use the graphical database management software (Navicat MySQL is a good choice) remote access to MySQL
Because there is no remote access permission, the method of opening remote access permission this site has but to remember to refresh the permissions, if not refresh permissions, restart the database can also.
Otherwise modified and not modified is a look, will continue to appear 1130 errors