By breastfeedingmomscafe.com on

I recently took my site offline to begin adding content. I returned to my site to login and got this error:

The mysql error was: Access denied for user 'breastf5_drp01'@'localhost' (using password: YES).

For one, that is NOT my password. I guess this is saying that someone logged into my database using the password YES. That is not my password and I did not take my site offline.

However, my site is now offline and I can not get to a login page using the usual command: http://mysite.com/?q=user. (I think that's right. You get the picture...)

I tried all the login page links posted by other users. Is there any other way into the site? THANKS!

⋅ Categories: Drupal 6.x

Comments

cayenne’s picture

cayenne commented

That's as in "YES" or "NO"--- not "yes" as the password. I had the same fear too.

WAAAAIT a minute!

The problem is that your DATABASE is not talking to your DRUPAL! The message you got comes when the username and password in your config file are bad. Either you need to edit your settings file or you will have a bigger problem.

Can you do that? Are you on dreamhost (has special problems)

:)

cayenne’s picture

cayenne commented

Looking at the error, it looks like you are using the database name in place of your database's username.

:)

breastfeedingmomscafe.com’s picture

breastfeedingmomscafe.com commented

I'm on Bluehost and I actually have an uncle who is helping me build a test site right now. We ran into a problem copying all of the database files over to the test site. When we went to the live site, we got that message and I got nervous just like you said.

Do you know if Bluehost is similar to Dreamhost? Can I fix it the way you describe or should I just contact them?

cayenne’s picture

cayenne commented

When you set up your bluehost database, you should get a username and a password. Sometimes, as on Dreamhost, youdo not use "localhost" but some other server name for the database server.

Other hosts add a prefix to your username without exactly mentioning it till you look for it, like "bfm1-bill" instead of just "bill"

YOu'll find it.

One trick I do sometimes is to use their "one-click install" if they have such a thing and then examine their settings file.

:)

yelvington’s picture

yelvington commented

The mysql error message indicates that Drupal was not able to connect with the database because the database username/password combination was rejected. YES simply indicates that a password was supplied, not that the password is YES. Check the username/password string in your settings.php file.