mysqlnd cannot connect to MySQL 4.1+ Error

[CalebF]

Hello,

Clients are receiving this error when trying to connect to their SiteBuilder after upgrading to 10.3...

[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

We've run the repair script with no luck, any ideas?

 

[PavelV]

could you please launch:

cd %plesk_bin%
local_mysql_helper.exe --repair-sitebuilder-database-user-password

?

 

[CalebF]

Command

Awesome,

That worked

 

[StefanD77]

Same error with older Clients Databases

Hello Pavel,

i've the same Problem with older Clients Databases after upgrading to 10.3!?
What can I do?

Why happened this?

Thanx,
Stefan

 

[PavelV]

i've the same Problem with older Clients Databases after upgrading to 10.3!?

Please try:

local_mysql_helper.exe --repair-all-users-password

 

[StefanD77]

Hello Pavel,

sorry, but this didn't work. Same error. What can I do?

-Stefan