phantom666 Posted April 9, 2016 Share Posted April 9, 2016 Username: demon666Domain: phantomtest.heliohost.orgServer: johnny Hi, I've just logged into my account following the recent upgrade, and I am no longer able to connect to any of my existing MySQL databases via the web. The affected databases are: demon666_demo2demon666_myDBdemon666_myassetdemon666_northwinddemon666_sakilademon666_sakila2demon666_testdbdemon666_wishlistdemon666_wpdbdemon666_wpdb2 Please can anyone assist? Thanks in advance. D Link to comment Share on other sites More sharing options...
wolstech Posted April 10, 2016 Share Posted April 10, 2016 This support request is being escalated to our root admin. Link to comment Share on other sites More sharing options...
Krydos Posted April 10, 2016 Share Posted April 10, 2016 Are you able to see your databases and the data through phpmyadmin? I did some further testing and it seems like host '127.0.0.1' is working, but host 'localhost' is not. Try changing to 127.0.0.1 and let us know if it works. Link to comment Share on other sites More sharing options...
phantom666 Posted April 10, 2016 Author Share Posted April 10, 2016 Hi, Thanks for getting back to me so quickly. Further to your last post, I can confirm that I am able to access my databases via phpmyadmin. The change you recommended (replacing "localhost" with "127.0.0.1") does appear to work. Quick question: does this mean that from now on the use of "localhost" in all php scripts should be replaced with "127.0.0.1", or is this just a temporary solution? Thanks in advance. D Link to comment Share on other sites More sharing options...
Krydos Posted April 10, 2016 Share Posted April 10, 2016 127.0.0.1 will always work so it's a safe way to make sure this doesn't happen again. I'm unsure why localhost isn't working. It's properly configured in the hosts file and the operating system itself resolves localhost to 127.0.0.1 properly. For some reason MySQL doesn't know what to do with localhost anymore. The crash must have conked Johnny on the head just right and he has a mild concussion. 1 Link to comment Share on other sites More sharing options...
Recommended Posts