By UrbanGrafix on

I was shifting my site so I backed up the mysql database + the site, and when I have tried to restore it (even in the orginal location with orginal files) I get the following error The mysql error was: Access denied for user 'engage_drpl1'@'localhost' (using password: YES).

I have checked the settings.php as it states but have been unable to find the problem in there.

"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 mysql error was: Access denied for user 'engage_drpl1'@'localhost' (using password: YES)."

I am not sure if its a config problem since it has been restored but before the backup it was perfect etc so I am assuming somthing with putting the files back has gone asque and even in their orginal location it gives me that problem.

I have edited a fair bit and want to keep it so does anyone have any idea? somthing wrong with the mysql? unsure please let me know what you think

⋅ Categories: Drupal 6.x

Comments

UrbanGrafix’s picture

UrbanGrafix commented

I have fixed it now. Thanks anyway

LancelotG’s picture

LancelotG commented

I'm having the same problem. How did you fix it?

LancelotG’s picture

LancelotG commented

I'll detail what I've done here while hoping someone could help me.

Based on Urban Grafix's suggestion that the problem was about adequation between the settings.php page and the mysql database, I've:

* Gone into the mysql console, selected the database (with USE)
* DROPped the user that was there (already i should have noticed something wrong when it told me that had affected 0 rows)
* CREATEd a new user, with a new password and all privileges.
* changed the settings.php file to reflect the new user and password.

Still no changes: I get the same error message when trying to access the website. Can somebody please help?

adrianoj’s picture

adrianoj commented

Hi all, I have the same problem, test many solutions as described...but nothing!

captcha’s picture

captcha commented

I had the same problem, solved it by changing the password to a simpler one, mine had @ symbols which was likely causing the error.

MamaGubs’s picture

MamaGubs commented

I have tried creating new users with and without passwords, and updating settings.php to match, to no avail. Mysqli error continues to show access denied, referencing the original user. I've cleared my browser cache, browsing history, closed the browser, truncated all the cache tables. No luck. Clearly, there is somewhere else that is holding the username and password, and I'm not finding it. Any ideas? (I just know this is going to be a stupid error on my part and will have to wear the dunce hat for the day)

Anonymous’s picture

Anonymous (not verified) commented

tried changing passwords, matching the setings.php file, but I can't solve it,
HELP please

dxevolution’s picture

dxevolution commented

I am having same problem too and have been trying to solve this since yesterday.
Does anyone know the solution?

rpruitt625’s picture

rpruitt625 commented

I would take drupal out of the mix.

Try logging into mysql either with command line, or PHPMyAdmin. Make certain your logon attempt uses the username/password combination that you are using in settings.php.