After migration, plesk still use old mysql password style

[DavideP]

Hi,

We have migrated from an old 9.5 plesk version to a new 10.4.

The problem is that if i change password, or i create a user (also of a new customer) in a mysql database, the password are created or updated with the old mysql style.

The server is working correctly, btw, also in php, with admin user with the new password style and all the imported users with old password style, what is not working is the database web admin button in the user control panel.

we want the opposite of:
http://kb.parallels.com/en/1758
so not setting old password style for all users, but new password styles for all users.
in psa.misc we have "mysql41_compatible" = "true".

right now, i have fixed setting the password with phpmyadmin (new style), but i need a stable fix because if a new user is created or if a password id updated, this will be done with the old mysql password style.

thanks,
Daniele Palumbo

 

[Nikolay.]

Plesk 11 automatically converts MySQL passwords into new format for all known users on upgrade.

In Plesk 10 you could comment out 'old_passwords=1' in MySQL configuration file and restart MySQL. This will enable using new password hashing scheme for all uses of PASSWORD() function (including creation of new users). Of course, old passwords mode can be enabled in other ways (e.g. via --old-passwords daemon option). Consult MySQL documentation if editing configuration file will not help.

[Edit] Regarding "mysql41_compatible" parameter in misc table. I don't think it is used in Plesk 10 at all.