{"id":1006,"date":"2013-11-03T11:54:03","date_gmt":"2013-11-03T15:54:03","guid":{"rendered":"http:\/\/wehuberconsultingllc.com\/wordpress\/?p=1006"},"modified":"2013-11-03T11:54:03","modified_gmt":"2013-11-03T15:54:03","slug":"iis-mysql-wordpress-and-the-famous-5-minute-installation","status":"publish","type":"post","link":"https:\/\/wehuberconsultingllc.com\/wordpress\/2013\/11\/03\/iis-mysql-wordpress-and-the-famous-5-minute-installation\/","title":{"rendered":"IIS, MySQL, WordPress, and The Famous 5-Minute Installation"},"content":{"rendered":"<p>Yesterday I was upgrading some programs on my home laptop and realized I had an old version of MySQL, 5.1. The current version is 5.6. The 5.1 version of MySQL was installed when I used Microsoft\u00e2\u20ac\u2122s Web Platform Installer to install a test WordPress blog. This is a really easy way to checkout software when it works so I set out to upgrade MySQL to the latest version. Surprisingly there is no way to upgrade or remove MySQL using the Web Platform Installer. So I downloaded the community upgrade from <a href=\"http:\/\/www.mysql.com\">www.mysql.com<\/a> and ran the upgrade. It did not work. I kept getting an unhandled exception error message during the upgrade. Since I did not have any important information in the data base I uninstalled the current version and installed the 5.6 version. Now MySQL is working but I kept getting password errors when I tried to install a new blog using either the Web Platform Installer or Microsoft\u00e2\u20ac\u2122s WebMatrix. So I did a complete MySQL reinstall using these <a href=\"http:\/\/serverfault.com\/questions\/88473\/how-can-i-reset-the-password-for-mysql\">instructions<\/a> for Windows 7 from <a href=\"http:\/\/www.serverfault.com\/\">serverfault.com<\/a>.<\/p>\n<ol>\n<li>Uninstall MySQL using the uninstaller. <\/li>\n<li>Delete C:\\Program Files\\MySQL <\/li>\n<li>Delete C:\\Program Files (x86)\\MySQL <\/li>\n<li>Delete C:\\ProgramData\\MySQL <\/li>\n<li>Delete from any Users&#8217; AppData folders. Example: C:\\Users\\rdoverby\\AppData\\Roaming\\MySQL <\/li>\n<li>Reinstall MySQL <\/li>\n<\/ol>\n<p>This did not fix my problems with Web Platform Installer or WebMatrix. Since I had <a href=\"http:\/\/www.phpmyadmin.net\/home_page\/index.php\">phpMyAdmin<\/a> working under IIS and a working version of MySQL, I opted to try \u00e2\u20ac\u0153The Famous 5-Minute Installation\u00e2\u20ac\u009d. I copied an old WordPress installation to a new folder, followed the instructions, and in about five minutes I had a new WordPress blog working on my laptop.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yesterday I was upgrading some programs on my home laptop and realized I had an old version of MySQL, 5.1. The current version is 5.6. The 5.1 version of MySQL was installed when I used Microsoft\u00e2\u20ac\u2122s Web Platform Installer to install a test WordPress blog. This is a really easy way to checkout software when &hellip; <a href=\"https:\/\/wehuberconsultingllc.com\/wordpress\/2013\/11\/03\/iis-mysql-wordpress-and-the-famous-5-minute-installation\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;IIS, MySQL, WordPress, and The Famous 5-Minute Installation&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[74,3],"tags":[141,123],"class_list":["post-1006","post","type-post","status-publish","format-standard","hentry","category-iis","category-wordpress","tag-iis","tag-wordpress"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4iN3d-ge","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts\/1006","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/comments?post=1006"}],"version-history":[{"count":1,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts\/1006\/revisions"}],"predecessor-version":[{"id":1007,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/posts\/1006\/revisions\/1007"}],"wp:attachment":[{"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/media?parent=1006"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/categories?post=1006"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wehuberconsultingllc.com\/wordpress\/wp-json\/wp\/v2\/tags?post=1006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}