连接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;