mysql problem

[marcos]

i installed pleks 7.5.4 via yum on a VSP (is it safe to use yum on a VPS?) and now i've:
mysql Ver 14.7 Distrib 4.1.14

When i try to run psarestore i get:

DBI connect('host=localhost;database=psa;mysql_socket=/var/lib/mysql/mysql.sock','admin',...) failed: Client does not support authentication protocol requested
by server; consider upgrading MySQL client at /usr/local/psa/lib/perl5/BU/DB.pm
line 38

ERROR: unable to connect to PSA database.



What's that?

In /etc/my.cfg i've:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
old_passwords=1

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[marcos]

after installation i added old_password=1 but didn't work

I entered plesk and set a new passwd for admin and then everythig was fine

Now the question is what will happen in case of upgrade?

The users created before the upgrade should work because their pwd was entered in old style . Am i right?

In other words can i upgrade to new mysql and add *after* the old-password entry hoping everthing will work or not??

Thanks

[Stucco]

I'm not sure, but users can have their passwords changed back to old ones with

set password for 'user'@'host' = OLD_PASSWORD('YOUR_PASSWORD_HERE');

[marcos]

I'm not sure, but users can have their passwords changed back to old ones with

set password for 'user'@'host' = OLD_PASSWORD('YOUR_PASSWORD_HERE');

That means that after upgrade i've to change the passwds for all the mysql users??

[Stucco]

The reason you had problems with that one password was because you didn't have old_passwords set when the user was updated.

I doubt you will hit any problems, but if you do, that's how to fix it.

[marcos]

The reason you had problems with that one password was because you didn't have old_passwords set when the user was updated.

I doubt you will hit any problems, but if you do, that's how to fix it.

Ok Stucco let me explain it better.

Now i need to upgrade a server. This server is runing 400 domains and many databse.

Do you suggest to entry 'old-password=1' in my.cnf *before* the upgrade or i've to do that after?

Maybe someone upgraded myslql and knows for sure the right procedure. I'am afraid to loos all the customers

Thanks

[Stucco]

Too much risk for me, I'm going to defer if anyone else wants to help.