HOW TO: Install MySQL as Part of a UNIX-to-Windows Migration

This article was previously published under Q323959
This article has been archived. It is offered "as is" and will no longer be updated.
MySQL is an open-source relationaldatabase management system (RDBMS) that supports the SQL query language. MySQL is available for most UNIX and Windows platforms, and it is typically used in combination with languages such as Perl, Python, and PHP. This article describes how to install MySQL on Windows.

back to the top

Obtain MySQL

To obtain MySQL, visit the following MySQL Web site: There are many packages available that support the MySQL database system; however, you have to install only the main MySQL RDBMS package. If you want additional functionality, such as an interactive MySQL query interface, see the additional packages that are available on the MySQL Web site.

back to the top

Install MySQL

To install MySQL:
  1. Unpack the MySQL distribution package by using WinZip.
  2. Change to the MySQL distribution folder, and then double-click Setup to start the MySQL Installer program.
  3. Click Next to continue the installation.
  4. Read the installation notes, and then click Next.
  5. Select the installation folder.

    The default location is C:\MySQL. To change this location, you must modify the MySQL configuration file (as described in the release notes that are included in the installation package). To change the location, click Browse to select a different installation folder, and then click Next.
  6. Click any of the following installation types, and then click Next:
    • Typical: This installation type includes all of the features that you must have to run MySQL.
    • Compact: This installation type installs only the minimum features that you must have to run MySQL.
    • Custom: If you select this installation type, you can select the features that you want to install.
  7. If you click Custom, you are prompted to select the features of MySQL that you want to install. After you click the features, click Next.
  8. After the files are installed, click Finish.
You must build the initial databases that are used to hold the grant and security information before you can start using the MySQL database. For more information about how to build these databases, see the MySQL documentation that is located in the Docs folder of the installation folder.

back to the top

For additional information about how to prepare servers for migration from UNIX to Windows , click the article number below to view the article in the Microsoft Knowledge Base:
323970 HOW TO: Prepare the Target Servers for a UNIX-to-Windows Migration

back to the top


Article ID: 323959 - Last Review: 02/27/2014 18:42:36 - Revision: 3.2

  • Microsoft Windows 2000 Server
  • Microsoft Windows 2000 Advanced Server
  • Microsoft Windows 2000 Professional Edition
  • Microsoft Small Business Server 2000 Standard Edition
  • Microsoft Internet Information Services 5.0
  • kbnosurvey kbarchive kbhowto kbhowtomaster KB323959