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. Accept the License Agreement and click Next.



7. Select Typical Installation and click Next.



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



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



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



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.