Likely related to Trac Ticket 8701. Use your forum login/password there if you are wanting to comment.
Thread Starter
nskim
(@nskim)
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
I’ve also been having trouble installing WordPress 2.7, probably because of php 5.3 incompatibilities. I am using php 5.3.0-dev that came with Glossword WAMP. At first I got the deprecation error messages and made the adjustments described by nskim. Now I only get a blank page, both when I let WordPress attempt to create the wp_config file or if I create it manually. Any suggestions?
I’m having the exact same problem as lclarkberg. Any suggestions?
Thread Starter
nskim
(@nskim)
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.
Thread Starter
nskim
(@nskim)
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!
Thread Starter
nskim
(@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
Hi all…
Found a way round the PHP 5.3 database connection issue. If you set your DB_HOST parameter to be a ‘hostname:port_number’ pair, it works.
E.g. on my system:
define('DB_HOST', 'localhost:3306');
(You might need to change hostname or port number)
