我可以真见识了 SELinux 的利害了, 这个问题让我找了好长时间的原因: 结果是 SELinux 不让 httpd 访问外网,昨天安装 Chrome 浏览器,结果不让 在根账号下运行 ..... SQLSTATE[HY000] [2003] Can't connect to MySQL server on 'XXX' (13) 解决方法:
Selinux 的设置 Can't connect to MySQL (13)
|
| 通过php的mysql_connect('localhost','usr','pass')连接本地数据库成功 但是,mysql_connect('127.0.0.1:3306','usr','pass')出现 can't connect to MySQL server using '' (13)的错误 原因: #getsebool -a | grep httpd [neo@neo phpMyTest]$ getsebool -a | grep httpd allow_httpd_anon_write --> off allow_httpd_mod_auth_ntlm_winbind --> off allow_httpd_mod_auth_pam --> off allow_httpd_sys_script_anon_write --> off httpd_builtin_scripting --> on httpd_can_check_spam --> off httpd_can_network_connect --> off httpd_can_network_connect_cobbler --> off httpd_can_network_connect_db --> off httpd_can_network_memcache --> off httpd_can_network_relay --> off httpd_can_sendmail --> off httpd_dbus_avahi --> on httpd_enable_cgi --> on httpd_enable_ftp_server --> off httpd_enable_homedirs --> off httpd_execmem --> off httpd_read_user_content --> off httpd_setrlimit --> off httpd_ssi_exec --> off httpd_tmp_exec --> off httpd_tty_comm --> on httpd_unified --> off httpd_use_cifs --> off httpd_use_gpg --> off httpd_use_nfs --> off 发现 httpd_can_network_connect --> off 解决方案:
#setsebool httpd_can_network_connect 1 ------------------------------------------------------------------------------------------------------------------------ Linux服务器下Can't connect to MySQL server on '' (10060) (转)
原始地址:http://bbs./viewthread.php?tid=1344552 远程连接服务器出现以上错误,解决后做了下总结,如有不正之处,请指正。 主要有三个原因: 1、mysql授权表里没有远程机器的权限,及需要在授权表mysql.user添加 grant all privileges on *.* to 'root'@'远程登陆IP' identified by '远程登陆密码' flush privileges; 2、网络不通,这个就不说了。 3、防火墙禁止3306端口,以iptable为例 vi /etc/sysconfig/iptables -A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306-j ACCEPT service iptables restart ps: iptables设置
|
|