Mysql连接错误

Question

我使用的是Magento ver-1.6.1。

当我尝试通过以下错误连接DB Magento时。

SQLSTATE[HY000] [2000] 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

我的MySql数据库在另一个域。我尝试从本地连接数据库。

感谢您的回复

我修改了数据库密码。现在它通过一个新的错误。

SQLSTATE[HY000] [2002] A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

Answer 1

您的MySQL服务器使用旧的身份验证机制，而mysqlnd无法遵守。mysqlld需要新的41字节密码，这是MySQL 4.1引入的(所以你不能连接到MySQL服务器<4.1)。要更新用户表以使用新密码方案，你必须在MySQL服务器上使用SET password命令，例如:

为'root'@'localhost'设置密码= PASSWORD('mypassword');

这将更改密码方案，并允许您连接mysqld。

Answer 2

尝试联系mysql主机管理。因为这不是magento的问题，而是服务器的问题。