MySQL is a powerful relational database that can handle many concurrent queries. It is an ideal componant in our development server.

Make use of the extensive MySQL online help.

MySQL Step 1.
Download MySQL and begin installation.

---

MySQL Step 2.
Click next at the welcome screen.

---

MySQL Step 3.
Select custom installation.

---

MySQL Step 4.
Chose an installation directory.

---

MySQL Step 5.
Follow the on screen instructions for the next 2 steps.

---

MySQL Step 6.
For now you can skip MySQL account creation.

---

MySQL Step 7.
Select configuration now and a new wizard will start.

---

MySQL Step 8.
Select detailed configuration.

---

MySQL Step 9.
Now select development machine.

MySQL Step 10.
Select Multifunctional Database.

---

MySQL Step 11.
Select where you want MySQL stores the data files.

---

MySQL Step 12.
We'll set the allowed concurrent connections to 10 which should be ample. Because this is only development server we don't want to waste a lot of resources on MySQL.

---

MySQL Step 13.
Configure the port and default character set.

---

MySQL Step 14.
Set MySQL as a Windows service and start it with Windows.

---

MySQL Step 15.
Define the root password

---

MySQL Step 16.
As a final step execute the configuration.




Now all of the main server components are installed.

Fine tune PHP

Starting from PHP 5 the MySQL support is not built in by default in the PHP interpreter. You can check it on your own fresh installed web server by checking the PHP Info page. See the Installing PHP section. Try to find the word mysql. There will be nothing.

Fine tuning Step 1.
To allow MySQL you have to edit a little bit the php.ini file. You can find it in the PHP installation directory. At the moment there are only a php.ini-dist and a php.ini-recommended files in this directory. These files contains the basic settings.

---

Fine tuning Step 2.
Rename the php.ini-recommended to php.ini.

---

Fine tuning Step 3.
Now open it for editing and try to find the line:
extension_dir
Change the line from
;extension_dir = "./"
to
extension_dir = "D:\Program Files\php\ext"
Take care that the first semicolon(;) was removed.

---

Fine tuning Step 4.
Next step is allow the MySQL extension. Try to find the line:
;extension=php_mysql.dll
Remove the semicolon from the first place.
Save the file.

---

Fine tuning Step 5.
To make sure that Apache will find the correct MySQL dll copy the libmysql.dll from the php directory into the Apache/bin directory.

---

Fine tuning Step 6.
Restart Apache and check the PHP Info page again. Now you have to find a MySQL section.

---

You now have a full working WAMP server installed on your PC. However the text line editor for MySQL is not the most user friendly. Install SQLYog a more user friendly interface for MySQL..