Setting Up the MySQL Database Server in the Windows Operating System
The document recommends a sequence of steps to set 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.
The recommended version of the product is MySQL Server 5.1. Downloads are available here. The instructions provided in the current document only apply to the Windows operating system. This document does not cover MySQL configuration details, it only describes a sequence of required steps.
For information about installing and configuring MySQL database server for other operating systems, refer to the MySQL documentation.
Starting the Installation
After the download is completed:
- On the Downloads panel, select the downloaded MySQL installation file and click Open. The MySQL Server Setup Wizard starts. On the Welcome panel, click Next.
- On the Setup Type panel, choose the Custom option and click Next.
- On the Custom Setup panel, click Next.
- On the Ready to Install the Program panel, click Install.
- On the MySQL Enterprise panel, click Next.
Configuring MySQL Server
- On the Wizard Completed panel, switch on the Configure MySQL Server now checkbox and click Finish. The MySQL server Instance Configuration Wizard starts.
- On the Welcome panel, click Next.
Specifying Configuration Type
- On the Configuration Type panel, choose the Detailed Configuration option. Click Next.
Note: Choosing this option is necessary to get to the panel for setting the network options where you will turn off the firewall for the port used by the MySQL server.
- Choose the Developer Machine option and click Next.
- Choose the Multifunctional Database option and click Next.
- On the InnoDB Tablespace Settings panel, choose the drive and \MySQL Datafiles\click Next.
- Specify the approximate number of concurrent connections to the server - choose the Decision Support (DSS)/OLAP option. Click Next.
Setting the Networking Options
- Switch on the Enable TCP/IP Networking checkbox.
- In the Port Number: edit-box, specify the connection port. The default setting is 3306 - leave it unchanged if there is not special reason to change it.
- Switch on the Add firewall exception for this port.
- Switch on the Enable Strict Mode checkbox. Click Next.
Setting the Character Set and the Operating System Options
- Specify the default character set and click Next.
- On the Set the Windows options panel, switch on the Install as Windows Service checkbox. To have the MySQL Server launched automatically, switch on the Launch the MySQL Server automatically checkbox. Click Next.
Specifying the Security Options
- Choose the Modify Security Settings option. !phpuser
- In the New root password, enter the root user's password.
- In the Confirm edit-box, retype the root user's password.
- Click Next.
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.
Completing the Configuration
- Click Execute to start the configuration.
- When the configuration is completed successfully, the information message appears. Click Finish.
: 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.