eb44345 Posted July 25, 2015 Posted July 25, 2015 I have been getting a strange problem with my site. Here is the error:Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'eb44345_eb44345'@'johnny.heliohost.org' (using password: YES) in /home/eb44345/public_html/PersonalityTypeQuiz/process_page5STP75.php on line 182 I cannot connect to my database anymore. It worked for months, then I changed nothing and one day it just stopped connecting to the database. No passwords were changed. No code was changed. Just stopped suddenly. I've tried deleting the entire database, deleting the user account and re-creating it and connecting it to that database, but nothing works. The thing is that it did work for a long time with no errors and suddenly it stopped working one day and hasn't worked since. Any idea how to fix this? BTW, the name of the database is eb44345_QuizResults
yashrs Posted July 25, 2015 Posted July 25, 2015 This support request is being escalated to our root admin.
Krydos Posted July 25, 2015 Posted July 25, 2015 Did you create a new database with that same name eb44345_QuizResults?
eb44345 Posted July 26, 2015 Author Posted July 26, 2015 Yes. I created a new database with that same name.
Krydos Posted July 27, 2015 Posted July 27, 2015 So, do you want me to delete that new database and restore your old data or are you sticking with the new database you created?
eb44345 Posted July 28, 2015 Author Posted July 28, 2015 If I could get the old data back that would be great. If not, it's okay as long as it is working.
Krydos Posted July 29, 2015 Posted July 29, 2015 The database eb44345_QuizResults should now be visible to your root mysql account. You may need to delete, recreate, and reassign permissions to any database users that should have access to the affected database. Let us know if you're still having any issues accessing your data.
eb44345 Posted July 30, 2015 Author Posted July 30, 2015 I deleted the user account, re-created it, then re-assigned it access rights to the database and I still get the error: Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'eb44345_eb44345'@'johnny.heliohost.org' (using password: YES) in /home/eb44345/public_html/PersonalityTypeQuiz/process_page5STP75.php on line 182 Not sure why it continues to be unable to connect to the database.
eb44345 Posted August 13, 2015 Author Posted August 13, 2015 Still does not work. I tried again deleting the user and re-creating the user, then adding the user to the database, but I still get this error:Warning: mysqli::mysqli(): (HY000/1045): Access denied for user 'eb44345_eb44345'@'johnny.heliohost.org' (using password: YES) in /home/eb44345/public_html/PersonalityTypeQuiz/process_page5STJ75.php on line 182
Recommended Posts