December, 2013 browsing by month


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:
  3. After product updates were completed, trying to connect to 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!

Fix for Wireless connection problem on a Lenovo T430 after Windows 8.1 Ugrade

Saturday, December 14th, 2013

Last night I upgraded my Windows 8 to 8.1 and this morning my wireless connection was lost on my Lenovo T430 machine. Remembered last time I had to manually download bunches of drivers from Lenovo site after I downgraded Windows 8 to Windows 7, so I quickly went to the site to download the driver software for Wireless LAN. I chose “Intel Wireless LAN (11abgn, 11bgn, 11ac) for Windows 8.1 (64-bit), 8 (64-bit), 7 (32-bit, 64-bit) – ThinkPad” to download and realized that the Windows 8.1 upgrade had already done that automatically and saved the driver at “grw208ww_64,exe“; without much suspect, I went ahead to run through the installation and it completed successfully but the “limited” status still showing below my wi-fi name.

I even upgraded the BIOS using the BIOS Util software downloaded from Lenovo site for Windows 8.1 but nothing changed. Well, as it turned out, Windows 8.1 upgrade automatically upgraded the driver software for wireless LAN but obviously the newer software wasn’t fully tested on every model of ThinkPad and it did not work on mine! So I ran the  “grw208ww_64,exe” and selected the “Uninstall” option to rollback. After that I located the previous driver downloaded several months earlier, “g1w216ww_s64.exe” and executed that. Immediately after the installation process completed, the yellow exclamation sign next to my wi-fi name disappeared and the wireless connection returned to normal.

So, this might be what had happened:

  • Intel heard Windows 8.1 coming and released an newest version of driver for it
  • Lenovo software QA director got inspired by the and ……the driver went live on Lenovo support site
  • Windows 8.1 upgrade tool automatically search for the latest driver from each vendor website that sold Windows 8 with their machines, found it, downloaded it and installed last night  (thank you Microsoft, appreciated that!!!)
  • But the newer does not mean better, it screwed me for 2 and half hours, plus 30 min to write this note up so it might save others from same frustration I went through.