Vipansh Posted June 30, 2016 Posted June 30, 2016 User: vipanshUrl: www.vipansh.comServer: stevie Site has been showing the "Error establishing database connection" message for the past few days. Quote
wolstech Posted June 30, 2016 Posted June 30, 2016 Change your cPanel password, then log out and in again. Delete and recreate your database users, then reassign them to the databases. Be sure you use the same password for the users as before (check in the config file for the software that uses the user to find it). Also, check in PhpMyAdmin to make sure your data is still in the databases. Odds are they're empty... Quote
Vipansh Posted June 30, 2016 Author Posted June 30, 2016 Also, check in PhpMyAdmin to make sure your data is still in the databases. Odds are they're empty... Does this affect my website's data? I mean, if it's empty, will all my data have gone? Quote
wolstech Posted June 30, 2016 Posted June 30, 2016 If its empty, your data is lost. You would need to create a new database with a different name and restore a backup. I would also recommend converting your tables to MyISAM. Innodb is ridiculously unreliable. Quote
Vipansh Posted July 2, 2016 Author Posted July 2, 2016 I have no idea what MyISAM or Innodb is. Any chances you could fix that for me?Also, when i try to log into phpMyAdmin, I get the HTTP Error 500 which says "stevie.heliohost.org is currently unable to handle this request."Nevermind, I deleted and recreated the user and assigned it back to the database, and it works now. Thanks a lot. I would still like help on converting to MyISAM. Quote
Guest Marko30 Posted July 2, 2016 Posted July 2, 2016 I have no idea what MyISAM or Innodb is. Any chances you could fix that for me? Also, when i try to log into phpMyAdmin, I get the HTTP Error 500 which says "stevie.heliohost.org is currently unable to handle this request." Nevermind, I deleted and recreated the user and assigned it back to the database, and it works now. Thanks a lot. I would still like help on converting to MyISAM.Have you tried changing your cPanel password as @wolstech suggested? You need to check "Synchronize MySQL password". 1 Quote
Vipansh Posted July 2, 2016 Author Posted July 2, 2016 I have no idea what MyISAM or Innodb is. Any chances you could fix that for me? Also, when i try to log into phpMyAdmin, I get the HTTP Error 500 which says "stevie.heliohost.org is currently unable to handle this request." Nevermind, I deleted and recreated the user and assigned it back to the database, and it works now. Thanks a lot. I would still like help on converting to MyISAM.Have you tried changing your cPanel password as @wolstech suggested? You need to check "Synchronize MySQL password". Changed the password and checked Synchronize MySQL password. It works now, and all my data is still there. Thanks! Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.