By korsakov on
"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 'example'@'localhost' (using password: YES)."
I removed cookies and tried to log in back with /?q=user/ but I receive the same message.
The site already worked. Does any know a remedy? Thank you!
Comments
If you are getting a mysqli
If you are getting a
mysqli error: Access denied for user 'example'@'localhost' (using password: YES)then the problem seems clear: The database server does not accept this information.Did 'example'@'localhost' contain your real username and password, or was it literally "username/password"? If it was "username/password", then Drupal is looking at an exact copy of default.settings.php which has been renamed to settings.php. That copy shouldn't exist, and causes exactly the error you described.
mysqli error: Access denied
"The mysqli error was: Access denied for user 'username for database'@'localhost' (using password: YES)"
Under /sites/default I have settings.php and default.settings.php. settings.php contains the right username/password. Do you want me to remove default.settings.php?
Thanks so much for your help!!!
clarification:
"The mysqli error was: Access denied for user 'username'@'localhost' (using password: YES)."
It contained my real username! I only want to get to the login page...
Sorry... I can't think of any reason
Sorry... I can't think of any reason why the database server would deny you access to the database if you used your database username and your database password.
Problem solved! Thanks!
The Host reset the password!
Heh!
Heh!
Case sensitive...
Look at the user id and password in settings.php, it's case sensitive...
Weird password error
I was moving my site into production, then a really weird error came.
The same as the poster of this threat the DB rejected the connection.
I was pretty sure the connection strings were right, cuz I used the same when I manually uploaded the DB
So I created a manual php file, which connects to the DB. Sadly to admit but it worked. So I had 2 php scripts using the SAME connection strings on the SAME server, on the SAME folder, one working and the other (the drupal one) wasn't...
I know it looks like the classic dumb mistake, but I'm sure I tested and reviewed it.
my password was: !+~O#WqRn6lM . Maybe some char conflicting with drupal
at this point, I went to the database
delete the old user
created a new user with the same name
granted permissions, just the same as before
tried again and voila! the DB was connecting
hi justaman, I did exact same
hi justaman,
I did exact same thing, but did not work for me.
I did into settings.php file like below:
$db_url = 'mysqli://myusername:mypassword@localhost/dxevolut_drupaldb';
username is: myusername
password is: mypassword
but still i am having same issue like below:
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 'dxevolut_dxblog'@'localhost' (using password: NO).
Can you help with this please. I am really having issue with this and need push the site into production by today :)
had exactly the same problem.
had exactly the same problem.
thanks for this post.
my password also had a "+" sign within it.
maybe this was the problem. (drupal 6.9)
i changed it and the site worked.
best regards
drupaljj