Installing MySql on Windows

Getting Ready

The MySQL server is the most popular database server, although you can use other database servers with the NetBeans IDE for PHP.

The recommended version of the product is MySQL Server 5.0. Downloads are available here. Click here for general instructions in installing and configuring the MySQL database server.

The instructions provided in the current document apply to the Windows operating system. The document recommends a sequence of steps to set up the MySQL database server for working in the PHP development environment.

While installing disable your firewall. To avoid security errors, install thorough Administrator login.

Starting the Installation

After the download is completed:

1. 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.
2. On the Setup Type panel, choose the Custom option and click Next.
3. On the Custom Setup panel, click Next.
4. On the Ready to Install the Program panel, click Install.
5. On the MySQL Enterprise panel, click Next.

Configuring MySQL Server

1. On the Wizard Completed panel, switch on the Configure MySQL Server now checkbox and click Finish. The MySQL server Instance Configuration Wizard starts.
2. On the Welcome panel, click Next.

Specifying Configuration Type

1. 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.
2. Choose the Developer Machine option and click Next.
3. Choose the Multifunctional Database option and click Next.
4. On the InnoDB Tablespace Settings panel, choose the drive and \MySQL Datafiles\click Next.
5. Specify the approximate number of concurrent connections to the server - choose the Decision Support (DSS)/OLAP option. Click Next.

Setting the Networking Options

1. Switch on the Enable TCP/IP Networking checkbox.
2. 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.
3. Switch on the Add firewall exception for this port.
4. Switch on the Enable Strict Mode checkbox. Click Next.

Setting the Character Set and the Operating System Options

1. Specify the default character set and click Next.
2. 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

1. Choose the Modify Security Settings option. !phpuser
2. In the New root password, enter the root user's password.
3. In the Confirm edit-box, retype the root user's password.
4. 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

1. Click Execute to start the configuration.
2. When the configuration is completed successfully, the information message appears. 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.

For more information follow this link