/********************************************************************* ERROR 1130: Host ’...′ is not allowed to connect to this MySQL server* 说明:*使用远程登录mysql,结果无法登录,记录一下解决方法,其中遇到的就是远程不能
* 访问,本地能访问,或者本地不能访问,远程能访问。* * -9-22 深圳 南山平山村 曾剑锋*******************************************************************/一、参考文档:1. 报错:1130-host ... is not allowed to connect to this MySql server 开放mysql远程连接 不使用localhost/xyzdw/archive//08/11/2135227.html2. 开启Mysql远程访问的所有方法 http://superyjcqw./blog/static/1610583057111040436/二、报错:1. ERROR 1130: Host ’...′ is not allowed to connect to this MySQL server2. ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY'三、解决办法:1. use mysql;2. update user set host='%' where user='root' and host='localhost';
3. GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'aplex' WITH GRANT OPTION; # 如果存在可以省略
4. UPDATE user SET Password=PASSWORD('your password') where USER='root' and host='127.0.0.1';5. select host, user from user;
四、shell登录:
mysql -h 127.0.0.1 -u root -p