php connect mysql

本文针对在使用PHP尝试连接本地MySQL服务器时出现的错误进行了详细分析,并提供了五个实用的解决方案,包括检查sock文件路径、验证MySQL配置、从命令行尝试连接等。

         mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket

 

Here are a couple random things to try with mySQL.

1. Is your mysql.sock file at /var/lib/mysql/mysql.sock?

2. Is mySQL accepting connections on localhost? Perhaps you have it configured to listen on your public IP address and not localhost.

3. Try connecting to your mySQL server from the command line using mysql -u username -p first and see what errors that is giving you.

4.Also, are you sure you want to use persistant connections? Are they enabled in your PHP configuration?

 

5.is  SELinux has something to do with this.

 

     最后我的在mysql_connect()的时候指定server 为127.0.0.1 或者为localhost.localdomain时mysql_connect连接正确了,就是把server设为localhost时出错!

评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值