Danny Gunawan

MySQL is a powerful open source database server which widely used by many hosting providers around the world. 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 Local Computer
• How to Install Apache in Windows
• How to Install PHP in Apache for Windows

MySQL Server Installation

• Run the downloaded mysql-essential-4.1.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 Custom for the Setup Type.

• Change the Install to folder to c:\apache\mysql for easier maintenance.

• Click Next to confirm and continue the installation process.

• Skip the MySQL.com account Sign-Up.

• 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-r10-win32.msi and follow the setup instructions.

• Change the installation folder to C:\apache\mysql\guitools\ for easier later maintenance.

• Select Complete Setup and continue to finish the installation.

• Although it might not necessary but I encourage you to restart your computer.

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.

In the next article I will describe “How to Install PHPMyAdmin in Apache for Windows”