2.10 Installing MySQL on Microsoft Windows

2.10.1 Choosing An Installation Package
2.10.2 Installing MySQL on Microsoft Windows Using an MSI Package
2.10.3 MySQL Server Instance Configuration Wizard
2.10.4 Installing MySQL on Microsoft Windows Using a noinstall Zip Archive
2.10.5 Troubleshooting a MySQL Installation Under Windows
2.10.6 Upgrading MySQL on Windows
2.10.7 Windows Postinstallation Procedures
2.10.8 Installing MySQL from Source on Windows
Important

The MySQL server 5.0 branch is old and not recommended for new installations. Consider installing the latest stable branch, which today is MySQL server 5.6.

A native Windows distribution of MySQL has been available since version 3.21 and represents a sizable percentage of the daily downloads of MySQL. This section describes the process for installing MySQL on Windows.

Note

If you are upgrading MySQL from an existing installation older than MySQL 4.1.5, you must first perform the procedure described in Section 2.10.6, “Upgrading MySQL on Windows”.

To run MySQL on Windows, you need the following:

For a list of limitations on the use of MySQL on the Windows platform, see Section D.7.6, “Windows Platform Limitations”.

There may also be other requirements, depending on how you plan to use MySQL:

MySQL for Windows is available in several distribution formats:

Generally speaking, you should use a binary distribution that includes an installer. It is simpler to use than the others, and you need no additional tools to get MySQL up and running. The installer for the Windows version of MySQL, combined with a GUI Configuration Wizard, automatically installs MySQL, creates an option file, starts the server, and secures the default user accounts.

Caution

Virus-scanning software such as Norton/Symantec Anti-Virus on directories containing MySQL data and temporary tables can cause issues, both in terms of the performance of MySQL and the virus-scanning software misidentifying the contents of the files as containing spam. This is due to the fingerprinting mechanism used by the virus-scanning software, and the way in which MySQL rapidly updates different files, which may be identified as a potential security risk.

After installing MySQL Server, it is recommended that you disable virus scanning on the main directory (datadir) used to store your MySQL table data. There is usually a system built into the virus scanning software to enable specific directories to be ignored.

In addition, by default, MySQL creates temporary files in the standard Windows temporary directory. To prevent the temporary files also being scanned, configure a separate temporary directory for MySQL temporary files and add this directory to the virus scanning exclusion list. To do this, add a configuration option for the tmpdir parameter to your my.ini configuration file. For more information, see Section 2.10.4.2, “Creating an Option File”.

The following section describes how to install MySQL on Windows using a binary distribution. To use an installation package that does not include an installer, follow the procedure described in Section 2.10.4, “Installing MySQL on Microsoft Windows Using a noinstall Zip Archive”. To install using a source distribution, see Section 2.10.8, “Installing MySQL from Source on Windows”.

MySQL distributions for Windows can be downloaded from http://dev.mysql.com/downloads/. See Section 2.5, “How to Get MySQL”.