By Upstream on

Hi,
I am a fairly new user of Drupal. Yesterday my database host required I change the password for the database. Now I get the following error message on my drupal website:
The mysqli error was: Access denied for user 'db_username'@'database.address.no' (using password: YES).

I have changed the password for the database in site/default/settings.php without that changing anything. I am confident my password is correct as I have no problem logging onto phpmyadmin. The new password does contain some special characters (though not quotes or apostrophe). I did experiment with escaping a special character without that changing anything either.

Is there someone out there with more experience and can give me a hint of other things to try to get my site back up and running? Thanks for any help!

⋅ Categories: Drupal 6.x

Comments

Upstream’s picture

Upstream commented

After a lot of testing, I decided to change my password slightly. I had used a plus-sign as part of the password for my database. When removing the '+' in the password, and changing my settings.php accordingly, it all worked.
I know from both the command line interface for mysql, as well as phpmyadmin, that the password with the '+' was accepted there. I have not found anywhere that a '+' needs to be escaped in a php-string. So, not sure what caused the '+'-containing password to mess things up - but happy to see it working.
If anyone knows why the '+' in a password did not work I am curious to hear from you!

centralh2o’s picture

centralh2o commented

I had a similar issue - The mysqli error was: Access denied for user 'db_username'@'database.address.no' (using password: YES).

Not really sure why it happened, except that I changed the mysql password, logged into mysql account, and logged out.

After logging out the error message still showed when trying to access my page. I cleared my temporary internet files in Internet Explorer and now the website loads fine. However, the admin pages are still showing the error message.

Any ideas?

centralh2o’s picture

centralh2o commented

I read http://drupal.org/node/374456 and followed the instructions there to fix the issue.

ogwin’s picture

ogwin commented

Hi,
I had the same error message when I used the backup_migrate module:
=============================================================
Site off-line
The site is currently not available due to technical problems. Please try again later. Thank you for your understanding.
_______________________________________________________________________________
If you are the maintainer of this site, please check your database settings in the settings.php file and ensure that your hosting provider's database server is running. For more help, see the handbook, or contact your hosting provider.
The mysqli error was: Access denied for user '(user)@'212.227.116.67' (using password: YES).
=============================================================
In spite I had the correct password in my settings.php!

I could solve the problem: in the database table
'backup_migrate_destinations'
there was the incorrect user/password !
After correcting, everything works fine!

Regards,