Learn to install Apache 2, MySQL 5, PHP 5, phpMyAdmin 2 and Zend Optimizer 3 on Windows XP (Install MySQL)

Open up the MySQL zip file that we've downloaded. Inside this zip file will be an installer file, named "setup.exe". This file can be extracted or ran just where it is. Double click or ran the setup file

image link:
http://library.monx007.com/pelengkap/install_mysql1.jpg

Once it's extracted and has been started, we'll get a screen similar to this.

Click >> Next

image link:
http://library.monx007.com/pelengkap/install_mysql2.jpg

The next screen we'll see will be the selection for the setup type for our installation. We're going to select Custom because we have a few custom requests for the installer to perform.

Click >> Next

image link:
http://library.monx007.com/pelengkap/install_mysql3.jpg

We will need to change the location for the installation, so we'll just select MySQL Server and then click on the Change button located in the bottom right.

image link:
http://library.monx007.com/pelengkap/install_mysql4.jpg

Simply type in the location, in this case we'll use "C:\server\mysql" as this is where the rest of our server applications are being installed. Then click on Ok.

image link:
http://library.monx007.com/pelengkap/install_mysql5.jpg

This will look like after we have customize the folder

Click >> Next

image link:
http://library.monx007.com/pelengkap/install_mysql6.jpg

We are now ready to install, just click on Install button

image link:
http://library.monx007.com/pelengkap/install_mysql7.jpg

When it's installing, we'll see a window similar to this and will disappear automatically when finished.

image link:
http://library.monx007.com/pelengkap/install_mysql8.jpg

This is to setup an account on MySQL.com for updates and so on, we'll just select Skip for the time being and we can take care of this later.

Click >> Next

image link:
http://library.monx007.com/pelengkap/install_mysql9.jpg

Now we get to configure the server to run the way we'd like for it to run. Just click Finish button

image link:
http://library.monx007.com/pelengkap/install_mysql10.jpg

This screen is the start page for the Server Instance Configuration Wizard.

Simply click on Next.

image link:
http://library.monx007.com/pelengkap/install_mysql11.jpg

We'll want to select Standard Configuration from the next screen. Remember this is for new installations of MySQL. Users that already have MySQL installed and are upgrading, please select Detailed Configuration.

Click >> Next

image link:
http://library.monx007.com/pelengkap/install_mysql12.jpg

Now we get to make a few choices about our server, for this project we'll use "Install As Windows Service" and make sure "Launch the MySQL Server automatically" option is checked. This will insure the MySQL server is started if it ever shuts down, or the system ever restarts.

Click >> Next

image link:
http://library.monx007.com/pelengkap/install_mysql13.jpg

Next we'll need to select a root password, simply type a password you'd like to use for root access and let's write it down so we don't forget it. Also remember to check "Enable root access from remote machines" ONLY IF you want to edit anything from a remote location later on.

image link:
http://library.monx007.com/pelengkap/install_mysql14.jpg

The next screen is simply the start screen for the configuration utility, letting us know what it's about to perform. Simply click on Execute.

image link:
http://library.monx007.com/pelengkap/install_mysql15.jpg

When Start Service is error, try to change the name of the service in previous screen (Choose Detailed Configuration)

image link:
http://library.monx007.com/pelengkap/install_mysql16.jpg

If there's an error like this screen, then, it maybe because your Computer Firewall block TCP port 3306 for connections. Just go to Start Program => Control Panel => Windows Firewall. If you haven't encounter this problem, you can skip to the next step HERE

image link:
http://library.monx007.com/pelengkap/install_mysql17.jpg

After that, click Exceptions tab, and click Add Port button

image link:
http://library.monx007.com/pelengkap/install_mysql18.jpg

Just insert:

Name: MySQL Connections

Port Number: 3306

and make sure, you choose TCP

Click >> OK

Click OK again to exit Windows Firewall options

Back to the MySQL Configuration Screen, press retry to continue the configuration


image link:
http://library.monx007.com/pelengkap/install_mysql19.jpg

Once everything is finished it will look like this. This give a little information about what has happened and show that everything goes well.
Click Finish button

Once we've finished the installation, we can run MySQL application to make sure that MySQL is installed and working properly.

image link:
http://library.monx007.com/pelengkap/install_mysql20.jpg

Find the folder in the start menu where MySQL is located and launch the "MySQL Command Line Client"

image link:
http://library.monx007.com/pelengkap/install_mysql21.jpg

Once it's open, simply enter the password we just set and if the client allows access with no errors, MySQL is now installed and working properly. There is no need to leave this command line client open, simply type "exit" and enter. This should close the client out.

We now have finished installing MySQL and it's working correctly. We can now move onto another application.

Source: Learn to install Apache 2, MySQL 5, PHP 5, phpMyAdmin 2 and Zend Optimizer 3 on Windows XP (Install MySQL)