Danny Gunawan

MySQL is a powerful open source database server which widely used by many world hosting providers. This article will guide you how to install MySQL in Apache for Windows.

This article assumes that you already read the preceding articles:

• How to Install Apache, PHP and MySQL in Windows – Preparation
• How to Install Apache 2.2 in Windows

MySQL Server Installation

• Run the downloaded mysql-essential-5.0.x-win32.msi file and follow the setup instructions. If you cannot run the downloaded file then you might need to install Microsoft Windows Installer.

• Select Typical Setup for the Setup Type.

• Make sure the Configure the MySQL Server now is checked after finish the installation. This option will open up the MySQL Server Instance Configuration Wizard.

• Select the Standard Configuration that used for machine that does not already have a MySQL server installation.

• Make sure to check Install as Windows Service and Launch the MySQL Server automatically.

• In security options, check the Modify Security Settings and type your root password. Make sure you uncheck the Enable root access from remoter machines for security.

• Click Execute to apply your configuration and finish setup.

MySQL GUI Tools

This is a single bundle including all GUI tools (MySQL Administrator, MySQL QueryBrowser and MySQL MigrationToolkit).

• Run the downloaded mysql-gui-tools-5.0-rx-win32.msi and follow the setup instructions.

• Select Complete Setup and continue to finish the installation.

Test Your Installation

• Check the MySQL Service Status

• Go to Start – Run

• Type services.msc and then click OK.

• The Services window will appear. Search the MySQL service and make sure the Status is started.

Next article: How to Install PHP 5 in Apache 2.2 for Windows