2011-12-01 12:34

Can't connect to MySQL server on 'XXX' (13)

我可以真见识了 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