If you are interested in using MySQL in your Windows Server whether for your development or a rock solid production system . MySQL is easy to setup and use and are fully supported in Windows as much as Linux. The usual setup LAMP which stand for Linux Apache MySQL and PHP no longer holds because you can also use MySQL in Windows IIS running with PHP. MySQL is currently available in Community and Enterprise Edition version 5.0.67. The steps below are easy to follow but first you have to download the installer from MySQL website. The following installation method can be used in Windows Server 2003 or Windows XP Systems.

• 1. After downloading just click on the file setup.exe to start the installation.
  
• 2. Select Detailed or Standard configuration continue by clicking next.
  
• 3. Select the type of server configuration you want from developer machine, server or dedicated MySQL.
  
• 4. Select the usage you intend to use for the database. Multifunctional, Transactional or Non-Transactional.
  
• 5. Select your installation Path.
  
• 6. Set your approximate number of concurrent connections.
  
• 7. Enable TCP/IP Networking and open port exemption on port number 3306, and enable strict mode.
  
• 8. Select your default character set, I prefer using UTF8 support.
  
• 9. Install MySQL server instance as service and add the bin path to Windows PATH variable for it to become accessible in the command prompt without navigating to your sub directories.
  
• 10. Configure your root password.
  
Your Ad Here
• 11. Click on execute and continue with your chosen configuration.
  
• 12. Finished everything and test your installed MySQL service instance.
  
• 13.Logged in your MySQL service instance to see if its running by issuing the following command on your Windows DOS console: mysql -u root -p it will prompt you for the password if you successfully installed it you will see the screen below and your MySQL is up and running.