StumbleUpon  Del.icio.us  Facebook  Reddit  Add to diigo  


Follow - Monx007
Article Time Stamp: 06 January 2010, 08:51:56 GMT+7

Learn to install Apache, MySQL, PHP, phpMyAdmin, Zend Optimizer and MySQL Tools 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



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

Click >> Next



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

NOTE: For Installing MySQL version 5.1.36, you can read HERE.




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.




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.



This will look like after we have customize the folder

Click >> Next



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



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



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



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



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

Simply click on Next.

If you installing MySQL version 5.0.22 Win32, click HERE to continue your installation tutorial.


At this point forward, here's the tutorial for installing MySQL version 5.1.36



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.

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.

This will look like after we have customize the folder.



Then we need to change the folder for MySQL data.



Choose MySQL Server Datafiles, then click on the Change button located in the bottom right.

Simply type in the location, in this case we’ll use “C:\server\mysql\Data” to store the MySQL data files (such as Database). Then click on Ok.

This will look like after we have customize the folder.



Click >> Next



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



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



This window is just some information about MySQL Enterprise edition. Just Click Next to continue the installation process.



This is to configure MySQL Server and setup an account on MySQL.com for updates and so on. We’ll just unselect the Register the MySQL Server now option for the time being and we can take care of this later. Click Finish.



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

Simply click on Next.





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.

If you reinstalling the MySQL server application, then you must use the Uninstall from Add/Remove Program at Control Panel. Then, you must manually delete the mysql folder that had been created by previous mysql installation.

Click >> Next



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



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.



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.



When Start Service is error, try to change the name of the MySQL service in previous screen.



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



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



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



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.



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



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.

Last but not least, you may want to look at MySQL Syntax Error And Solutions for any warnings / errors that you may find.




 << Install Apache   Install PHP >> 

INDEX SHORTCUT



Article Source: Monx Digital Library

Copyrighted@ Monx Digital Library, otherwise stated
Use of our service is protected by our Terms of Use



 Back To Previous Page ...  



 

 

 

AQWorlds Nulgath Secret Walkthrough