将代码部署到测试服务器的时间出现No such file or directory,检查nginx日志出现PHP message: PHP Warning: mysql_connect(): No such file or directory。经过检查发现原来是mysqlnd连接不到数据库,修改php的配置文件mysql.default_socket = /var/lib/mysql/mysql.sock 注意我这边是yum安装的mysql server,重新启动php-fpm.如果你使用的是apache的话则启动apache的服务即可。
使用mysql_connect('localhost','root','123')发现服务器又报错
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD(‘your_existing_password’). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
update mysql.user set password=password('123456') where user='root';
update mysql.user set password=password('123456') where user='test';
flush privileges;
mysql> select user,length(password) from mysql.user;
+--------------+------------------+
| user | length(password) |
+--------------+------------------+
| root | 41 |
| test | 41 |
+--------------+------------------+