Install MySQL on a Windows Server

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 steps:

  1. Log into your server through Terminal Services or Remote Desktop Connection.
  2. Open a Web browser and load http://dev.mysql.com/downloads/
  3. Download Windows (x86) ZIP/Setup.exe (there’s no need to sign up.  It is a free download).
  4. Unzip the file you downloaded above and run Setup.exe.

  5. Click Next to begin the installation wizard.

    6. MySQL Installation

  6. Accept the License Agreement and click Next.

    7. MySQL Installation

  7. Select Typical Installation and click Next.

    8. MySQL Installation

  8. Click Install. The installation will take a few moments.

    9. MySQL Installation

  9. Click Next until you reach the Wizard Completed screen.
  10. Check Configure the MySQL Server now and click Finish.

    11. MySQL Installation

  11. Click Next to begin the MySQL Server Instance Configuration Wizard.

    12. MySQL Installation

  12. Select Detailed Configuration and click Next.

  13. Select Server Machine and click Next.

  14. Select Multifunctional Database and click Next.

  15. For InnoDB Tablespace Settings, leave the default settings and click Next.

  16. Select Online Transaction Processing (OLTP) and click Next.

  17. Check Enable TCP/IP Networking, leave the default Port Number and click Next.

  18. Select Standard Character Set and click Next.

  19. Check Install as Windows Service, uncheck Include BIN directory in Windows PATH and click Next.

  20. Enter a password for your root user, uncheck Create an Anonymous Account and click Next.

  21. Click Execute to complete the installation.
Category: General IT Stuff, Windows Server 2003, Windows Server 2008 /R2