Add a database server fails - mysqlnd cannot connect to MySQL 4.1+ error

[sismservice]

We have a Plesk 11.0 server and we want to use a separate DB server. See server details below:

Webserver:
Redhat EL 5.8-64
Parallels Plesk - 100 Domain w/ Power Pack 11.0.9 Linux
mysql 5.0.95-1.el5_7.1

DB Server:
Redhat EL 5.8-64
NO Plesk
mysql 5.0.95-1.el5_7.1

When we attempt to "Add Database Server" and complete the information we get the following error:

"Error: Test connection to the database server has failed:

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"

Anyone have a suggestion?

We did find this info:
http://stackoverflow.com/questions/...ysql-4-1-using-the-old-insecure-authenticatio

But the MySQL GUI Tools (http://dev.mysql.com/downloads/gui-tools/5.0.html) referenced are no longer available.

Has anyone been successful in adding a database server in a similar setup?

Matt

 

[EugeneKazakov]

Here is solution, but it is in russian, but queries are clear:
1. Connect your db-server via ssh
2. Remove old_passwords = 1 from my.cnf
3. Open mysql console
4. Update mysql.user table in order to have valid passwords

 

[sismservice]

Thank You - I have confirmed this worked -

 

[IgorG]

Already discussed here http://forum.parallels.com/showthread.php?t=263585