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

?

?