mycw

If you’re using PHP 4.3.9 and MySQL client/server 4.1 you may actually get the following error while connecting during installation.

Error w/ php: mysql_connect(): Client does not support authentication protocol

You can verify this problem by editing wp-includes/wp-db.php. Look under function wpdb. Change the last line in the ‘die’ statement to
</div>” . mysql_error());
i.e adding mysql_error() so you actually see the MYSQL error.

If you get the above MYSQL error then you can fix this by doing logging into mysql and do the following:

SET PASSWORD FOR ‘user’@’localhost’ = OLD_PASSWORD(‘password’);

Also checkout: http://forums.mysql.com/read.php?11,6400,6701#msg-6701

This fixes the “Error establishing a database connection” problem for me.

If you’re using PHP 4.3.9 and MySQL client/server 4.1 you may actually get the following error while connecting during installation.

Error w/ php: mysql_connect(): Client does not support authentication protocol

You can verify this problem by editing wp-includes/wp-db.php. Look under function wpdb. Change the last line in the ‘die’ statement to
</div>” . mysql_error());
i.e adding mysql_error() so you actually see the MYSQL error.

If you get the above MYSQL error then you can fix this by doing logging into mysql and do the following:

SET PASSWORD FOR ‘user’@’localhost’ = OLD_PASSWORD(‘password’);

Also checkout: http://forums.mysql.com/read.php?11,6400,6701#msg-6701

This fixes the “Error establishing a database connection” problem for me.