解决方法:
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

本文介绍了当使用PHP连接本地MySQL数据库遇到Can't connect to MySQL server on 'XXX' (13)错误时的解决办法。主要原因是SELinux的安全策略阻止了HTTP服务与MySQL服务器之间的网络连接。通过调整SELinux的布尔值设置,允许HTTP服务进行网络连接,从而解决了该问题。
1119

被折叠的 条评论
为什么被折叠?



