I had WordPress mu alpha 6 setup with bbpress integration. I went into bbpress admin -> settings -> WordPress integration. When I saved the settings I get an error message that admin cannot connect to the sql server. Now, I can’t log into bbpress. Here’s the error:

mysql_connect() [function.mysql-connect]: Access denied for user 'admin'@'localhost' (using password: YES) in /home/greath6/public_html/bb/bb-includes/backpress/class.bpdb.php on line 123

I know I can delete my bbpress install, remove the bbpress tables, re-install and it will work again. But, I’ve already done that twice! Anyone know a real solution to this happening or why it happens?

[@westpointer Member 15 years, 11 months ago]

One other comment – I have this same configuration setup on three other servers (different hosts) and it works fine. This host is php 5.2.8; mysql – 5.0.51a-community-log

[@westpointer Member 15 years, 11 months ago]

BTW – I have this same configuration working fine on three other servers that are all on different hosts. This host is php 5.2.8; mysql 5.0.51a-community-log. I’ll check what versions the other servers have but that seems fine.

[@asbjornu Member 15 years, 10 months ago]

I’m having the same problem and it seems that the WP integration for whatever mysterious reason forces the MySQL connection into “localhost” mode. I’ve configured both WP and bbPress to connect to another MySQL host, but still it seems like bbPress is trying to connect to “localhost”.

I added a print_r($args) inside the db_connect_host() function and found that the function is called twice and the first time the credentials, host, etc., are correct and the second time they aren’t. The second time the function is called, the credentials are for some reason set to the ones of the logged in user. So somewhere in the bbPress code, authentication is done not with the values stored in bb-config.php, but with the username and password of what’s stored in the session cookie and the host is then set to “localhost”.

I don’t know how to investigate this problem any further.

[@asbjornu Member 15 years, 10 months ago]

After some more digging, I’ve found that the perpetrator is the db_connect() function inside class.bpdb-multi.php. I don’t understand why that file should be in use on a non-multi WP/bbPress installation, but either way it’s that file that does the offensive db_connect_host() call with erroneous credentials, host, etc.

What’s really weird is that the front page of bbPress works, while opening a topic yields the “Access denied for user ‘admin’@’localhost’ (using password: YES)” error message. Why would class.bpdb-multi.php be in use on a topic page but not on the front page? Makes no sense.

[@sambauers Participant 15 years, 10 months ago]

The class.bpdb-multi.php class is used everywhere.

Have you somehow accidentally entered your WordPress admin username and password in the WordPress user database settings area?

[@asbjornu Member 15 years, 10 months ago]

Hi, Sam, and thanks for the reply and attention. The bb-config.php and wp-config.php files are practically identical, so the answer to your question is: no.

[@sambauers Participant 15 years, 10 months ago]

I need to see the actual settings to know what’s going wrong. Email me here if you want to setup a login for me so I can have a look at what’s happening http://unlettered.org/send-me-letters/

[@asbjornu Member 15 years, 10 months ago]

Thanks, Sam. I’ve sent you an e-mail.