{"id":1552,"date":"2009-07-16T23:03:35","date_gmt":"2009-07-16T18:03:35","guid":{"rendered":"http:\/\/www.beingmanan.com\/wp\/?p=1552"},"modified":"2009-11-12T20:56:49","modified_gmt":"2009-11-12T15:26:49","slug":"install-mysql-phpmyadmin-on-windows-for-iis","status":"publish","type":"post","link":"https:\/\/beingmanan.com\/wp\/2009\/07\/install-mysql-phpmyadmin-on-windows-for-iis\/","title":{"rendered":"Install MySQL &#038; phpMyAdmin On Windows For IIS"},"content":{"rendered":"<p align=\"justify\">If you\u2019re like me and get the urge to mess around with your PC then this might interest you or if you\u2019re seriously looking to setup an IIS Server along with MySQL &amp; phpMyAdmin then again, this is for you. This is a quick how-to\u00a0for setting up MySQL &amp; phpMyAdmin on Windows if you\u2019re planning to install WordPress or any such application dependent on these technologies. There are other options like Xampp but I\u2019d like to talk about how one can set these components individually. Setting up an IIS Server is quite easy &amp; so is MySQL &amp; phpMyAdmin, so here\u2019s how:<\/p>\n<p><!--more--><\/p>\n<ul>\n<li>\n<h6><strong>Setting up IIS (Windows 7):<\/strong><\/h6>\n<\/li>\n<\/ul>\n<p align=\"justify\">To do this follow these steps:<\/p>\n<ol>\n<li>\n<div>Start \u2013&gt; Control Panel<\/div>\n<\/li>\n<li>\n<div>Programs \u2013&gt; Uninstall a program<\/div>\n<\/li>\n<li>\n<div>Turn Windows features on or off (left sidebar)<\/div>\n<\/li>\n<li>\n<div>Check \u2018Internet Information Services\u2019 &amp; \u2018Internet Information Services Hostable Web Core\u2019.<\/div>\n<\/li>\n<li>\n<div>OK. Sreenshot:<\/div>\n<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"http:\/\/afpfjg.bay.livefilestore.com\/y1povxJP58C9CxPF0pMz59l06oSMdT4fnCYXYbfZWJSr1qmC5i8p3VrqsV4jY29mgM_joNONKAuxrYRBULTyOQVRw\/iis-setup-01.png\" alt=\"install iis7 on windows 7\" \/><\/p>\n<p align=\"justify\">Once the installation is done, you\u2019ll have to start the server. To do this:<\/p>\n<ol>\n<li>\n<div>Start<\/div>\n<\/li>\n<li>\n<div>Search for IIS \u2013&gt; Select IIS Manager<\/div>\n<\/li>\n<li>\n<div>Select your PC from the left sidebar &amp; hit \u2018Start\u2019 on the right sidebar. Screenshot:<\/div>\n<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"http:\/\/afpfjg.bay.livefilestore.com\/y1pnPLTkgefTJO26vXi8kRMNi9Uh7IcAMNx6qUqdDxnBoHqSS1Ba0qWPwzL3QUmLGY7XeH2M_Q3EL4siQAHgaITjw\/iis-setup-02.png\" alt=\"start iis server windows\" \/><\/p>\n<ul>\n<li>\n<h6><strong>Install MySQL:<\/strong><\/h6>\n<\/li>\n<\/ul>\n<p align=\"justify\">Now that IIS is installed, we\u2019ll set up MySQL, to do that:<\/p>\n<ol>\n<li>\n<div><a href=\"http:\/\/dev.mysql.com\/downloads\/mysql\/5.1.html#win32\" target=\"_blank\">Download MySQL Essentials<\/a><\/div>\n<\/li>\n<li>\n<div>Run the setup<\/div>\n<\/li>\n<li>\n<div>Select the \u2018Typical\u2019 setup &amp; keep hitting Next &amp; Install.<\/div>\n<\/li>\n<\/ol>\n<p align=\"justify\">Screenshots:<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/afpfjg.bay.livefilestore.com\/y1p4pZkb3GTOldtaXM7ZRy-RcsEyUKHtWXuf-e2q8KQIXDUxFyWnTyszwcdXc_et73GmMyverN28jtAOYgMHK2Y8A\/mysql-01.PNG\" alt=\"installing mysql on windows\" \/><\/p>\n<p><img decoding=\"async\" src=\"http:\/\/afpfjg.bay.livefilestore.com\/y1ptVSWvrw3KgBadQLqPMh8NBECuc8WrfvvHE1FyUd8DD51ssKOXKkydcONxXExx2KnJ0oAiixFuSfyKoCTItXxNA\/mysql-02.PNG\" alt=\"mysql on windows\" \/><\/p>\n<p align=\"justify\">Once MySQL wizard completes it will ask you whether you want to register the server &amp; if you want to configure the server. To save time &amp; hassle, we\u2019ll uncheck the registration option &amp; will configure the server, screenshots:<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/afpfjg.bay.livefilestore.com\/y1pAfnA3lidZluRt7SzvSBekYlorYLogz_KdaWwZ20HYy0RMdpLXIbAZwE-4Pzo_gqPLpOttznGykBY2yUNxKGF4A\/mysql-03.PNG\" alt=\"installing mysql on windows\" \/><\/p>\n<p align=\"justify\">We\u2019ll choose the Standard configuration &amp; enter the required details. Configurations screenshots:<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/afpfjg.bay.livefilestore.com\/y1pUwxWZVjQ8S1DzhlSMUWOpHoCryxqsX_KsCk5pyrubYvtCMcwcScFewPlyuod59nmnBej-YY3_AXBjr44OLOjPw\/mysql-04.PNG\" alt=\"mysql windows setup\" \/><\/p>\n<p align=\"justify\">Security settings, I\u2019d suggest keep something that you\u2019ll remember &amp; nothing to complicated. Set the MySQL service to auto run saving you time. Screenshots:<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/afpfjg.bay.livefilestore.com\/y1p4IpRm6HVcCMnrfmcpvdUNfTpm_2pIm54KdbXal9EXbUYEsIw0Jz3xWzrQMzUSKPn88NV7N_9YQuwn616FYngNw\/mysql-05.PNG\" alt=\"\" \/><\/p>\n<p><img decoding=\"async\" src=\"http:\/\/afpfjg.bay.livefilestore.com\/y1pLWLCF0xvEdrMMBQNTU4nlbyB4gjChpS5chsYuB285vv5s2GqVeUj4MHqcY8VvsaGl9yICabvtHfGwa5-sKBcGQ\/mysql-06.PNG\" alt=\"mysql wndows configuration\" \/><\/p>\n<p align=\"justify\">Last screen, press \u2018Execute\u2019 &amp; once done, \u2018Finish\u2019. You\u2019re done with MySQL installation &amp; setup. :)<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/afpfjg.bay.livefilestore.com\/y1pX4s5xDxMDDeMZqZ6oiiM9l3j8qVnrtjVk0FA-tNuakMZebJoJoD6c8MyJ1SjRBwmXrc2Ioik4xXffR1AU9HzGQ\/mysql-07.png\" alt=\"mysql windows installation complete\" \/><\/p>\n<ul>\n<li>\n<h6><strong>Installing phpMyAdmin:<\/strong><\/h6>\n<\/li>\n<\/ul>\n<p align=\"justify\">We\u2019ll be installing phpMyAdmin as it&#8217;s a GUI to managing the tables:<\/p>\n<ol>\n<li>\n<div><a href=\"http:\/\/www.phpmyadmin.net\/home_page\/downloads.php\" target=\"_blank\">Download the phpMyAdmin zip file<\/a><\/div>\n<\/li>\n<li>\n<div>Extract it to:<\/div>\n<ul>\n<blockquote>\n<div>C:\\inetpub\\wwwroot\\phpmyadmin<\/div>\n<\/blockquote>\n<\/ul>\n<\/li>\n<li>\n<div>Now navigate to the same directory &amp; rename the file <strong>config.sample.inc.php <\/strong>to <strong>config.inc.php<\/strong><\/div>\n<\/li>\n<li>\n<div>Open the file in Notepad &amp; find<\/div>\n<ol>\n<blockquote>\n<div>$cfg[&#8216;blowfish_secret&#8217;] = \u2018 \u2019;<\/div>\n<\/blockquote>\n<\/ol>\n<\/li>\n<li>\n<div>Within the \u2018 \u2019 insert any word, eg: manan. The line should look like:<\/div>\n<ul>\n<blockquote>\n<div>$cfg[&#8216;blowfish_secret&#8217;] = &#8216;manan&#8217;;<\/div>\n<\/blockquote>\n<\/ul>\n<\/li>\n<li>\n<div>Save the file. Note that the file name should be <strong>config.inc.php<\/strong><\/div>\n<\/li>\n<li>\n<div>In your browser, go to:<\/div>\n<ul>\n<blockquote>\n<div>localhost\/phpmyadmin<\/div>\n<\/blockquote>\n<\/ul>\n<\/li>\n<li>\n<div>And that\u2019s it, login with the credentials you provided during the MySQL. If all\u2019s done right &amp; the php God\u2019s are smiling you should see your login page, something like this:<\/div>\n<\/li>\n<\/ol>\n<p><img decoding=\"async\" src=\"http:\/\/afpfjg.bay.livefilestore.com\/y1pwB-nyHsqaFnzUs4Za82k7fmOqnJCpFMzmleEgzybctVVm0scN7fgvFluoaNlUeDDAQEc5rNyJ8D3OTxONOg5xg\/phpmyadmin.PNG\" alt=\"phpmyadmin windows login\" \/><\/p>\n<p><img decoding=\"async\" src=\"http:\/\/afpfjg.bay.livefilestore.com\/y1pcTquSLkQ_-2FXsUG5El3-Z5r2tvrv3f104y8u5fsqR29v_KOqIcYdqwPB48wOo7iDfKDWEtwMJKjEUF0F9153RnoH-69f-ca\/phpmyadmin-02.PNG\" alt=\"\" \/><\/p>\n<p align=\"justify\">~Enjoy!<\/p>\n<p align=\"justify\">Wait for the follow up post that would explain my reasoning for going through all of this :)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Setting up MySQL server &#038; phpMyAdmin on Windows running IIS 7 &#038; WIndows 7. Works with Vista as well.<\/p>\n<div class=\"read-more-wrapper\"><a class=\"read-more\" href=\"https:\/\/beingmanan.com\/wp\/2009\/07\/install-mysql-phpmyadmin-on-windows-for-iis\/\" title=\"Read More\"> <span class=\"button default\">Read More<\/span><\/a><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"googlesitekit_rrm_CAow7K6iCw:productID":"","_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":[37],"tags":[653,652,651,137,552,7,38],"class_list":["post-1552","post","type-post","status-publish","format-standard","hentry","category-computing-and-internet","tag-iis","tag-mysql","tag-phpmyadmin","tag-tutorial","tag-utilities","tag-windows","tag-wordpress"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/beingmanan.com\/wp\/wp-json\/wp\/v2\/posts\/1552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/beingmanan.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/beingmanan.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/beingmanan.com\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/beingmanan.com\/wp\/wp-json\/wp\/v2\/comments?post=1552"}],"version-history":[{"count":8,"href":"https:\/\/beingmanan.com\/wp\/wp-json\/wp\/v2\/posts\/1552\/revisions"}],"predecessor-version":[{"id":1558,"href":"https:\/\/beingmanan.com\/wp\/wp-json\/wp\/v2\/posts\/1552\/revisions\/1558"}],"wp:attachment":[{"href":"https:\/\/beingmanan.com\/wp\/wp-json\/wp\/v2\/media?parent=1552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/beingmanan.com\/wp\/wp-json\/wp\/v2\/categories?post=1552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/beingmanan.com\/wp\/wp-json\/wp\/v2\/tags?post=1552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}