MySQL authentication failure

[ChipMonk]

Few weeks back i updated my one server through YUM.

When i create database and user through plesk, it is created.

but when i put the information in the configuration files, it gives the following errors:

Could not connect to database: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Check your database settings in the config.php file.

I have FC2, plesk 7.5.4, box updated by YUM ART



any help?

[scott]

is old_passwords=1 set in /etc/my.cnf?

[ChipMonk]

is old_passwords=1 set in /etc/my.cnf?

here is the complete my.cnf file:

[mysqld]
safe-show-database
innodb_data_file_path=ibdata1:10M:autoextend
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

[scott]

Very weird, thats the first thing I would have thought of to check. Is the authentication info being stored in cleartext? I think I recall another person telling me they had to convert all their password fields to md5 when they upgraded to 4.1.

[ChipMonk]

Very weird, thats the first thing I would have thought of to check. Is the authentication info being stored in cleartext? I think I recall another person telling me they had to convert all their password fields to md5 when they upgraded to 4.1.

Well i absolutely have no idea where on earth (i mean on server) and how it is stored.

[scott]

You'd have to dig into the application and look at what mysql tables its accessing.

[ChipMonk]

Well, I figured out the problem

I didnt update the users, so the problem existed

I simply regenerated the databases and it worked out.


Thanks for the help

[scott]

ah mysql_fix_privilege_tables?

[ChipMonk]

ah mysql_fix_privilege_tables?

Nope.

I simply deleted the database, and recreated it. As i had only two sites at the moment those needed quick fixes.

As all the old databases were okay, so i took the rule, If it aint broken, dont fix it :p