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.
Starting the Download
- Go to http://dev.mysql.com/downloads/installer/.
- Click the Download button.
- Save the installer file to your system.
Starting the Installation
After the download completes, run the installer as follows:
- Right-click the downloaded installation file (for example, mysql-installer-community-18.104.22.168.msi) and click Run.
The MySQL Installer starts.
- On the Welcome panel, select Install MySQL Products.
- On the License Information panel, review the license agreement, click the acceptance checkbox, and click Next.
- On the Find latest products panel, click Execute.
When the operation is complete, click Next.
- On the Setup Type panel, choose the Custom option and click Next.
- On the Feature Selection panel, ensure MySQL Server 5.6.x is selected, and click Next.
- On the Check Requirements panel, click Next.
- On the Installation panel, click Execute.
When the server installation is completed successfully, the information message appears on the Installation panel. Click Next.
- On the Configuration panel, click Next.
- At the first MySQL Server Configuration page (1/3), set the following options:
- At the second MySQL Server Configuration page (2/3), set the following options:
- Root Account Password.
- MySQL Root Password. Enter the root user's password.
- Repeat Password. Retype the root user's password.
Note: The root user is a user who has full access to the MySQL database server - creating, updating, and removing users, and so on. Remember the root password - you will need it later when creating a sample database.
- MySQL User Accounts. Click Add User to create a user account. In the MySQL User Details dialog box, enter a user name, a database role, and a password (for example, !phpuser). Click OK.
- At the third MySQL Server Configuration page (3/3), set the following options:
- Windows Service Name. Specify a Windows Service Name to be used for the MySQL server instance.
- Start the MySQL Server at System Startup. Leave the checkbox selected if the MySQL server is required to automatically start at system startup time.
- Run Windows Service as. Choose either:
- Standard System Account. Recommended for most scenarios.
- Custom User. An existing user account recommended for advanced scenarios.
- At the Configuration Overview page, click Next.
- 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.