{"id":679,"date":"2012-05-02T21:06:34","date_gmt":"2012-05-02T21:06:34","guid":{"rendered":"http:\/\/microsoftgeek.com\/?p=679"},"modified":"2012-05-02T21:06:34","modified_gmt":"2012-05-02T21:06:34","slug":"install-mysql-on-a-windows-server","status":"publish","type":"post","link":"https:\/\/microsoftgeek.com\/?p=679","title":{"rendered":"Install MySQL on a Windows Server"},"content":{"rendered":"

The following article explains how to install MySQL on a Windows Server. The process involves downloading the latest version of MySQL directly to your Windows server and then installing the software. MySQL is a free product. Once installed, you may begin creating and using MySQL databases on your server.<\/p>\n

To install MySQL, please follow these steps:<\/h2>\n
    \n
  1. Log into your server through Terminal Services or Remote Desktop Connection.<\/li>\n
  2. Open a Web browser and load http:\/\/dev.mysql.com\/downloads\/<\/a><\/li>\n
  3. Download Windows (x86) ZIP\/Setup.exe <\/strong>(there’s no need to sign up. \u00a0It is a free download).<\/li>\n
  4. Unzip the file you downloaded above and run Setup.exe<\/strong>.<\/li>\n

    \"\"<\/p>\n

  5. Click Next<\/strong> to begin the installation wizard.<\/li>\n

    \"MySQL<\/p>\n

  6. Accept the License Agreement and click Next<\/strong>.<\/li>\n

    \"MySQL<\/p>\n

  7. Select Typical Installation<\/strong> and click Next<\/strong>.<\/li>\n

    \"MySQL<\/p>\n

  8. Click Install<\/strong>. The installation will take a few moments.<\/li>\n

    \"MySQL<\/p>\n

  9. Click Next<\/strong> until you reach the Wizard Completed<\/strong> screen.<\/li>\n
  10. Check Configure the MySQL Server now<\/strong> and click Finish<\/strong>.<\/li>\n

    \"MySQL<\/p>\n

  11. Click Next<\/strong> to begin the MySQL Server Instance Configuration Wizard.<\/li>\n

    \"MySQL<\/p>\n

  12. Select Detailed Configuration<\/strong> and click Next<\/strong>.<\/li>\n

    \"\"<\/p>\n

  13. Select Server Machine<\/strong> and click Next<\/strong>.<\/li>\n

    \"\"<\/p>\n

  14. Select Multifunctional Database<\/strong> and click Next<\/strong>.<\/li>\n

    \"\"<\/p>\n

  15. For InnoDB Tablespace Settings<\/strong>, leave the default settings and click Next<\/strong>.<\/li>\n

    \"\"<\/p>\n

  16. Select Online Transaction Processing (OLTP)<\/strong> and click Next<\/strong>.<\/li>\n

    \"\"<\/p>\n

  17. Check Enable TCP\/IP Networking<\/strong>, leave the default Port Number<\/strong> and click Next<\/strong>.<\/li>\n

    \"\"<\/p>\n

  18. Select Standard Character Set<\/strong> and click Next<\/strong>.<\/li>\n

    \"\"<\/p>\n

  19. Check Install as Windows Service<\/strong>, uncheck Include BIN directory in Windows PATH<\/strong> and click Next<\/strong>.<\/li>\n

    \"\"<\/p>\n

  20. Enter a password for your root user, uncheck Create an Anonymous Account<\/strong> and click Next<\/strong>.<\/li>\n

    \"\"<\/p>\n

  21. Click Execute<\/strong> to complete the installation.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    The following article explains how to install MySQL on a Windows Server. The process involves downloading the latest version of MySQL directly to your Windows server and then installing the software. MySQL is a free product. Once installed, you may begin creating and using MySQL databases on your server. To install MySQL, please follow these […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,4,6],"tags":[],"class_list":["post-679","post","type-post","status-publish","format-standard","hentry","category-computer-tech-stuff","category-general-2003-stuff","category-general-2008"],"_links":{"self":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/679","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=679"}],"version-history":[{"count":2,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/679\/revisions"}],"predecessor-version":[{"id":681,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=\/wp\/v2\/posts\/679\/revisions\/681"}],"wp:attachment":[{"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=679"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=679"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/microsoftgeek.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=679"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}