连接mysql数据库报错解决方法_MySQL

bitsCN.com

连接mysql数据库报错解决方法

 

1.mysql 错误 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost'

     

解决办法：关闭防火墙，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;

用root账户从任何主机上访问mysql数据库了 

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

如果你想允许用户zz从ip为192.168.1.3的主机连接到mysql服务器，并使用123456作为密码

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.1.3' IDENTIFIED BY '123456' WITH GRANT OPTION;
 

bitsCN.com