Mysql 1130 error solution 1. error 1130-Host 'ipaddr 'is not allowed to connect to this MySQL server 2. The cause of the problem is that no authorization is granted, therefore, access is denied.
SQL code # mysql-uroot-p Enter password: Welcome to the MySQL monitor. commands end with; or \ g. your MySQL connection id is 17 Server version: 5.1.69 Source distribution Copyright (c) 2000,201 3, Oracle and/or its affiliates. all rights reserved. oracle is a registered trademark of Oracle Corporation and/or its affiliates. other names may be trademarks of their respective owners. type 'help; 'or' \ H' for help. type '\ C' to clear the current input statement. mysql> grant all privileges on *. * TO 'root' @ '%' identified by 'sunnorth' with grant option; Query OK, 0 rows affected (0.00 sec) mysql> flush privileges; Query OK, 0 rows affected (0.00 sec) mysql> exit Bye
Sunnorth is the new authorization password, which can be customized to this point and completed.