nskim

One more thing about annoying errors messages.

Those warning messages will go away when you enable error_log in php.ini file.

error_log=c:\tmp\php.log

Ok, one of our developers has come up with a solution for this.

The problem appears to be that the /etc/my.cnf file has a directive:

old_passwords=1

which needs to be changed to

old_passwords=0

and then the mysqld server restarted, and then the passwords need to be reset.

This eliminates the old passwords from the database.

Good luck!

The problem turns out to be it’s a php 5.3 issue. Php 5.3 uses mysqlnd(mysql native driver) instead of mysqllib.dll. This mysqlnd uses an old password authentication method which is used below mysql 4.1.

But, I need to know how to mysqlnd uses the new style password authentication method. Please, let me know anybody knows how to disable old password authentication. Thanks.

Thanks for your quick response and sorry for delayed reply.

I’ve upgraded WP from 2.6.1 to 2.7 and there is an issue with connecting database. I think it’s a PHP 5.3 specific issue since PHP 5.2.6 and 5.2.8 work fine.

The following is the actual error message.

Error establishing a database connection
This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at aaa.bbb.ccc.ddd. This could mean your host’s database server is down.

Are you sure you have the correct username and password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?
If you’re unsure what these terms mean you should probably contact your host. If you still need help you can always visit the WordPress Support Forums.

However, the same configuration works with other versions of PHPs. Any resolution for this?

Thanks,
Kim