al1001 Posted October 4, 2015 Share Posted October 4, 2015 My site has been down for couple of weeks now (at least that's when I checked to see if my site is working or not). I get the error " Error establishing a database connection" and can't even get to the Wp-login. I tried all the troubleshooting tips provided in the forum, but still not working. Someone said my database is deleted somehow. Not sure how that's even possible or it's even true. Requesting administrator's help please. I can provide my info via private message. Thanks Link to comment Share on other sites More sharing options...
al1001 Posted October 6, 2015 Author Share Posted October 6, 2015 Anyone?? Link to comment Share on other sites More sharing options...
wolstech Posted October 7, 2015 Share Posted October 7, 2015 You need to change the database user password. You do that here at the bottom: http://stevie.helioh.../sql/index.html After changing it, verify the new password matches what's in your website's config file (wp-config.php in your case). Link to comment Share on other sites More sharing options...
al1001 Posted October 7, 2015 Author Share Posted October 7, 2015 I did what you suggested, but now it's asking me to install WordPress. Not sure why it would ask me to install WordPress when I already have a site that was up-and-running. When I type in my site URL, it redirects me to the link below asking me to install WordPress: http://www.mywebsite.com/wp-admin/install.php Thank you! Link to comment Share on other sites More sharing options...
wolstech Posted October 7, 2015 Share Posted October 7, 2015 Check that your database contains expected tables in phpmyadmin. If the tables say "in use", you won't be able to use them and will need to either wait until innodb is fixed, or drop them and reinstall Wordpress (which will delete your content). Link to comment Share on other sites More sharing options...
al1001 Posted October 12, 2015 Author Share Posted October 12, 2015 Whole database seems to be gone in mySQL. I really don't know what happened and why it was deleted. Link to comment Share on other sites More sharing options...
wolstech Posted October 15, 2015 Share Posted October 15, 2015 You're welcome! I'm glad to see you got it working. Link to comment Share on other sites More sharing options...
al1001 Posted October 18, 2015 Author Share Posted October 18, 2015 I don't know who IFeelStupid member is, but I started this thread originally and my site is still not working. It shows DB is zero size. Link to comment Share on other sites More sharing options...
wolstech Posted October 18, 2015 Share Posted October 18, 2015 The fix for yours should be the same as the fix for his. Both of you have the same issue. Delete and recreate all your database users. Make sure when you recreate the database user, the password needs to match what's in wp-config.php, and it must be assigned to the correct database with all privileges . Also verify that your databases actually contain data. Check in PHPMyAdmin, if the tables say "in use" for collation, the only solution is to drop them and rebuild your site from scratch, or wait weeks if not months hoping we restore support for the storage engine they use. If you can't get into PhpMyAdmin, change your cpanel password, log out, then back in and try again. The "zero size" in cPanel is not an indicator of missing data, but rather is caused by passwords being out of sync, is erroneous, and can be ignored. Changing your cPanel password might help, though mine always show zero despite being filled with data. Link to comment Share on other sites More sharing options...
Krydos Posted November 2, 2015 Share Posted November 2, 2015 Ifeelstupid, your thread has been split to http://www.helionet.org/index/topic/22477-site-down-after-mysql-upgrade-ifeelstupid/ Link to comment Share on other sites More sharing options...
Recommended Posts