al1001 Posted October 4, 2015 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
wolstech Posted October 7, 2015 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).
al1001 Posted October 7, 2015 Author 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!
wolstech Posted October 7, 2015 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).
al1001 Posted October 12, 2015 Author Posted October 12, 2015 Whole database seems to be gone in mySQL. I really don't know what happened and why it was deleted.
wolstech Posted October 15, 2015 Posted October 15, 2015 You're welcome! I'm glad to see you got it working.
al1001 Posted October 18, 2015 Author 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.
wolstech Posted October 18, 2015 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.
Krydos Posted November 2, 2015 Posted November 2, 2015 Ifeelstupid, your thread has been split to http://www.helionet.org/index/topic/22477-site-down-after-mysql-upgrade-ifeelstupid/
Recommended Posts