Today I tried to install PHP and MySQL on my local Windows XP Pro machine. Both were working fine individually but I couldnot 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 phpinfo() function.
It was showing Configuration File (php.ini) Path = C:\php\php.ini which is correct and I did not have any php.ini on any other location. Everytime I make changes, I was restarting the IIS Server but any how changes were not reflected. In resetting IIS what I was following was 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. For IIS restart run the following command on Dos prompt.
And boom. I got my php correctly configured and now I can connect to MySQL from PHP code.