Setting Up the MySQL Database Server in the Windows Operating System

The MySQL database server is one of the most popular open-source database servers commonly used in web application development.

This document recommends a sequence of steps to set up the MySQL database server 5.6 versions in the Windows operating system. It does not cover MySQL configuration details, it describes a sequence of required steps.

For information about installing and configuring MySQL database server for other operating systems, refer to the Installing and Upgrading MySQL documentation.

Note: The Setting Up the MySQL Database Server 5.1 versions in the Windows Operating System document provides the instructions on setting up the 5.1 versions of MySQL Server on Windows.

Contents

Starting the Download

  1. Go to http://dev.mysql.com/downloads/installer/.
  2. Click the Download button.
  3. Save the installer file to your system.

top

Starting the Installation

After the download completes, run the installer as follows:

  1. Right-click the downloaded installation file (for example, mysql-installer-community-5.6.10.0.msi) and click Run.
    The MySQL Installer starts.
  2. On the Welcome panel, select Install MySQL Products.
  3. On the License Information panel, review the license agreement, click the acceptance checkbox, and click Next.
  4. On the Find latest products panel, click Execute.
    When the operation is complete, click Next.
  5. On the Setup Type panel, choose the Custom option and click Next.
  6. On the Feature Selection panel, ensure MySQL Server 5.6.x is selected, and click Next.
  7. On the Check Requirements panel, click Next.
  8. On the Installation panel, click Execute.
    When the server installattion is completed successfully, the information message appears on the Installation panel. Click Next.
  9. On the Configuration panel, click Next.
  10. At the first MySQL Server Configuration page (1/3), set the following options: Click Next.
  11. At the second MySQL Server Configuration page (2/3), set the following options: Click Next.
  12. At the third MySQL Server Configuration page (3/3), set the following options: Click Next.
  13. At the Configuration Overview page, click Next.
  14. When the configuration is completed successfully, the information message appears on the Complete panel. Click Finish.

    Note: To check that the installation has completed successfully, run the Task Manager. If the MySQLd-nt.exe is on the Processes list - the database server is running.

top

Send Feedback on This Tutorial

See Also

top