MySql/Wordpress

...now browsing by category

 

Mysql Database repaired after Windows 8.1 upgrade

Friday, December 20th, 2013

Another disaster came with the Windows 8.1 upgrade over weekend ¬†was discovered Monday morning when I was in desperate need for my local WordPress blog where I kept tons of valuable info for the project I have been working on. I clicked on the blog link and got an “Error establishing a database connection” message. Using that error message to search Google and returned many complaints about the same problem and basically it was that the upgrade has somehow disabled the underneath MySQL database. ¬†Below were the steps I took to fix the problem and got my WP blog back online:

  1. Launched MySql installer and first selected Add/Modify Products and Features:

    Started MySql Installer to remove and reinstall MySql database engine

    Started MySql Installer to remove and reinstall MySql database engine

  2. First applied all the updates:
    MysqlInstaller_3
  3. After product updates were completed, trying to connect to 127.0.0.1: 3306 and still got the database not connected error; so decided that un-installing and re-installing MySql Database engine was the only option.
    MySql DB Uninstall
  4. When asked if to clean the existing data, did not check the “Remove server datafiles” option or I would lost all my old blogs!
    MySql DB Uninstall - 2
  5. After uninstalled, relaunched the MySql Installer and re-installed the MySql 5.6 Community Edition (default):
    MySql DB re-install
  6. After installation, just followed the configuration process through and added the same user account back (find user account info in wp-config.php); started the MySql Workbench and made sure it could connect to local host instance.
  7. Then that’s it! I browsed to the same work blog site and everywhere was sunshine again!