Atomicorp

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?

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

scott wrote: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

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.

scott wrote: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.

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

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

ah mysql_fix_privilege_tables?

scott wrote: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