Installing MySQL

• Web Designer
• Skills
• Portfolio
• Tutorials
• Contact
• Books for sale

Installing MySQL on Windows XP

<< Installing PHP

Installing MySQL
Go to your desktop and inside the folder you have initially created find file mysql-5.0.41.win32.zip. Extract the content of this file to the same folder on the desktop. Now go inside mysql-5.0.41-win32 folder and double click Setup.exe. Follow the steps:

Fig. 18 - Click next.


Fig. 19 - Select Custom and click next.


Fig. 20 - Click Change button to change the path of the installation.


Fig. 21 - Navigate to C:\webserver\mysql and click OK, then click next.


Fig. 22 - Click Install to start installation.


Fig. 23 - During installation a new window will pop up introducing MySQL Enterprise. Simply click next twice to continue with your installation.


Fig. 24 - Your installation is finished. You are now ready to configure your MySQL Server. Click Finish to start configuration.

MySQL Configuration

Fig. 25 - On the first screen click next.


Fig. 26 - Select Detailed Configuration and click next.


Fig. 27 - Select Developer Machine and click next.


Fig. 28 - Select Multifunctional Database and click next.


Fig. 29 - Leave everything as default and click next.


Fig. 30 - Select Decision Support (DSS)/OLAP and click next.


Fig. 31 - Leave two options checked and port number as 3306 and click next.


Fig. 32 - Select Standard character Set and click next.


Fig. 33 - Select Include Bin Directory in Windows PATH and leave other options as default. Click next.


Fig. 34 - Tick Modify Security Settings and type in a password you want to use to access MySQL server, then click next.


Fig. 35 - Click Execute to apply configuration settings.


Fig. 36 - Click Finish to exit configuration wizard.

The last thing you need to do is to open php.ini file located in C:\webserver\php and uncomment the line extension=php_mysql.dll by removing semicolon ; at the beginning. Save the file and close it. Restart the computer.

This way you have completed your installation and you are now ready to start developing your web applications using Apache, PHP and MySQL.
Good Luck!

<< Installing PHP