一、#2002 - 服务器没有响应 (or the local MySQL server's socket is not correctly configured) |
原因:这个问题一般是由于不能通过mysql.sock来连接数据库。一般php.ini不需要修改的,但有些未知的原因需要指定mysql.default_socket的值,mysql.sock的路径根据你的mysql的安装会有所不同。
解决方法:
1、确定MYSQL服务器的mysql.sock的路径,可以用命令netstat -nap |grep mysql去查看。我的服务器是/tmp/mysql.sock。
2、编辑php.ini
mysql.default_socket = /tmp/mysql.sock
mysql.default_socket = /tmp/mysql.sock
3、重新启动apache服务器即可。
二、#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client |
you entar in the mySql command line client and enter the following command SET PASSWORD FOR 'user'@'host' = OLD_PASSWORD('password');
example:
my user: is peter, my password: something and my host: localhost
my user: is peter, my password: something and my host: localhost
the command will be:
SET PASSWORD FOR
peter@localhost
= OLD_PASSWORD('something');