bitscn.com
mysql 1130 error解决
错误现象
解决方法
一、错误现象
1130 - host ‘ipaddr’ is  not allowed to connect to this mysql server
二、解决方法
出现改问题的原因是没有授权，所以拒绝访问
sql代码 # 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, 2013, 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为授权后的新密码，可自定义
至此、完成。
bitscn.com