PHP + Apache + MySQL perfect setup

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.

---

At the moment you have a full working WAMP server installed on your PC. However to work easy it is recommended some useful tools for MySQL tasks and for PHP coding. You will get the information on the next page.

article index
page 1 : untitled page
page 2 : Installing PHP
page 3 : Installing MySQL - Part 1
page 4 : Installing MySQL - Part 2
page 5 - current : Fine tune PHP
page 6 : MySQL Management
page 7 : MySQL skills
page 8 : PHP IDE