Question

连接mysql数据库失败怎么办

Answer 1

1 mysql 错误 ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost'
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;
用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;

Answer 2

首先看报错窗口。
1

首先远程连接进入服务器，在cms中输入m...
2

输入use mysql;
3

输入select user,password,host from u