2.3.3. Installing MySQL on Microsoft Windows Using the MSI Package

The MSI package is designed to install and configure MySQL in such a way that you can immediately get started using MySQL.

The MySQL Installation Wizard and MySQL Configuration Wizard are available in the Essentials and Complete install packages. They are recommended for most standard MySQL installations. Exceptions include users who need to install multiple instances of MySQL on a single server host and advanced users who want complete control of server configuration.

The workflow sequence for using the installer is shown in the figure below:

Figure 2.1. Installation Workflow for Windows using MSI Installer

Installation Workflow for Windows using MSI

Microsoft Windows XP and later include a firewall which specifically blocks ports. If you plan on using MySQL through a network port then you should open and create an exception for this port before performing the installation. To check and if necessary add an exception to the firewall settings:

  1. First ensure that you are logged in as an Administrator or a user with Administrator privileges.

  2. Go to the Control Panel, and double click the Windows Firewall icon.

  3. Choose the Allow a program through Windows Firewall option and click the Add port button.

  4. Enter MySQL into the Name text box and 3306 (or the port of your choice) into the Port number text box.

  5. Also ensure that the TCP protocol radio button is selected.

  6. If you wish, you can also limit access to the MySQL server by choosing the Change scope button.

  7. Confirm your choices by clicking the OK button.

Additionally, when running the MySQL Installation Wizard on Windows Vista, ensure that you are logged in as a user with administrative rights.


When using Windows Vista, you may want to disable User Account Control (UAC) before performing the installation. If you do not do so, then MySQL may be identified as a security risk, which will mean that you need to enable MySQL. You can disable the security checking by following these instructions:

  1. Open Control Panel.

  2. Under the User Accounts and Family Safety, select Add or remove user accounts.

  3. Click the Got to the main User Accounts page link.

  4. Click on Turn User Account Control on or off. You may be prompted to provide permission to change this setting. Click Continue.

  5. Deselect or unceck the checkbox next to Use User Account Control (UAC) to help protect your computer. Click OK to save the setting.

You will need to restart to complete the process. Click Restart Now to reboot the machine and apply the changes. You can then follow the instructions below for installing Windows.

Copyright © 2010-2022 Platon Technologies, s.r.o.           Home | Man pages | tLDP | Documents | Utilities | About
Design by styleshout