• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

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

sismservice

New Pleskian
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
 
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
 
Back
Top