php - 我的服务器无法连接到 mysql

Question

我有用于游戏服务器的服务器 x。我有mysql5.5。当我将服务器连接到数据库时，我收到了这条消息

Client does not support authentication protocol requested by server; consider upgrading MySQL client

my.ini 设置为 old_passwords=1

mysql> SHOW VARIABLES like 'old_passwords';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| old_passwords | 1     |
+---------------+-------+
1 row in set

当我尝试使用 mysql 4.0.27-nt-max 时，它可以成功连接。但我不能使用 php 连接 db mysql 4.0.27-nt-max

Answer 1

如果你身边还有 MySQL 4.0 的副本，我猜你也有一个古老版本的 PHP。

https://support.zend.com/hc/en-us/articles/203838366-mysql-connect-Client-does-not-support-authentication-protocol

Many older PHP builds use the MySQL client API for MySQL 3.23.x. If you use an older PHP build (with the old MySQL API) then you will get the Client does not support authentication protocol error when trying to connect to a MySQL server 4.1.x or above.

The recommended solution is to upgrade your PHP to the latest ...