作者：初升的太阳1866 | 来源：互联网 | 2014-06-09 00:50
连接mysql数据库报错解决方法1.mysql错误ERROR2003(HY000):Can'tconnecttoMySQLserveron'localhost'www.2cto.com解决办法：关闭防火墙，linux下命令[root@etl01bin]#...
1.mysql 错误 ERROR 2003 (HY000): Can&＃39;t connect to MySQL server on &＃39;localhost&＃39;
www.2cto.com
解决办法：关闭防火墙，linux下命令
[root@etl01 bin]# chkconfig --list | grep -i iptables ====check fire wall
iptables 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[root@etl01 bin]# /sbin/service iptables stop ====stop fire wall
Flushing firewall rules: [ OK ]
Setting chains to policy ACCEPT: nat filter [ OK ]
Unloading iptables modules: [ OK ]
2.报错:1130-host ... is not allowed to connect to this MySql server
解决办法：
授权形式
比如账户为root,密码为root
use mysql;
GRANT ALL PRIVILEGES ON *.* TO &＃39;root&＃39;@&＃39;%&＃39; IDENTIFIED BY &＃39;root&＃39; WITH GRANT OPTION;
如果你想允许用户zz从ip为192.168.1.3的主机连接到
mysql服务器，并使用123456作为密码
GRANT ALL PRIVILEGES ON *.* TO &＃39;root&＃39;@&＃39;192.168.1.3&＃39; IDENTIFIED BY &＃39;123456&＃39; WITH GRANT OPTION;
京公网安备 11010802041100号