当前位置:Gxlcms > mysql > 连接mysql数据库报错解决方法_MySQL

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

时间:2021-07-01 10:21:17 帮助过:19人阅读

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

人气教程排行