• The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

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