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.
Vishal Monpara is a full stack Solution Developer/Architect with 13 years of experience primarily using Microsoft stack. He is currently working in Retail industry and moving 1’s and 0’s from geographically dispersed hard disks to geographically dispersed user leveraging geographically dispersed team members.