Today I tried to install PHP and MySQL on my local Windows XP Pro machine. Both were working fine individually but I could not connect to the MySQL from PHP code. I tried to change
php.ini file but no matter what I do, changes were not reflected when I tried
php.ini File Location Verified
I verified that
php.ini is at the correct location and I did not have any
php.ini on any other location.
Every time I make changes, I was restarting the IIS Server but somehow changes were not reflected.
IIS Server Restarted – Wrong Way
When I was restarting IIS Server, these are the steps I was following.
Go to Control Panel > Administrative Tools > Internet Information Services > Expand [Computer Name] > Expand Website > Right Click on Default Website and press Stop button and again start it.
But after sometime I realized that this is NOT IIS restart. It is just Website restart.
IIS Server Restart – Correct Way
For IIS restart run the following command on Command Prompt. Make sure you open Command Prompt with “Run as administrator”.
And boom. I got my php correctly configured and now I can connect to MySQL from PHP code.