PHP5 connection to MySQL problem

[Frank Lopes]

I've seen many people asking the same question in other forums but I haven't been able to solve this problem.

First the environment:
Windows Vista Ultimate running IIS6

Now the story:
Installed PHP and configured it in IIS with no problems.
Installed MySQL with no problems.
Both up and running except that PHP will not recognize the presence of MySQL

Using all the recommendations that I saw (some of them conflicting recommendations...) I tried the following:

Modified the php.ini file so that the extensions entries (the drive map and the DLLs) are being pointed to the correct EXT location.
Restarted ISS and ran a test page with phpinfo() and the MySQL sections are not there.

Modified the os path environment variable to include the PHP folder...Restarted ISS and ran a test page with phpinfo() and the MySQL sections are not there.

Moved the php.ini to the windows folder ... Restarted ISS and ran a test page with phpinfo() and the MySQL sections are not there.

Manually added the IUSRS user to the list of users of the file... in case it was a matter of permissions...Restarted ISS and ran a test page with phpinfo() and the MySQL sections are not there.

Moved the libmysql.dll to the windows/system32 folder ... Restarted ISS and ran a test page with phpinfo() and the MySQL sections are not there.

I think I tried every permutation of file locations for the php.ini file and for the DLL files (php_mysql.dll and php_mysqli.dll) Restarted ISS after each change and ran a test page with phpinfo() and the MySQL sections are not there.

I've reached the end of my rope trying every possibility...

Anyone has managed to get these 2 to talk to each other in a vista system?
Does anyone have any ideas?

Thank you for your help in this matter

[nathj]

Hi Frank,

I have managed to get PHP and MySQL to commuinicate on Windows Vista Business using IIS7.

I had a lot of bother achieving this but in the end, after trying many configurations I did the following:
1) Cleared all web server software off the machine
2) Completely removed PHP and all associated files.
3) Left MySQL where it was
4) Installed IIS7 again
5) Teseted //localhost to be sure
6) Downloaded the PHP msi file and installed it ensuring to select mySQL extensions during the installation process.
7) Configured IIS to know about PHP and recognise it properly

After this I was able to see the MySQL section under phpInfo() and all was well. The two things talk happily.

I hope this helps
nathj

[Frank Lopes]

Thanks for the recommendation... but....

I don't recall, at the time of the PHP installation, being prompted to select the MySQL extensions...

In a matter of fact, I'm sure I was not.

Hi Frank,

I have managed to get PHP and MySQL to commuinicate on Windows Vista Business using IIS7.

I had a lot of bother achieving this but in the end, after trying many configurations I did the following:
1) Cleared all web server software off the machine
2) Completely removed PHP and all associated files.
3) Left MySQL where it was
4) Installed IIS7 again
5) Teseted //localhost to be sure
6) Downloaded the PHP msi file and installed it ensuring to select mySQL extensions during the installation process.
7) Configured IIS to know about PHP and recognise it properly

After this I was able to see the MySQL section under phpInfo() and all was well. The two things talk happily.

I hope this helps
nathj

[nathj]

Thanks for the recommendation... but....

I don't recall, at the time of the PHP installation, being prompted to select the MySQL extensions...

In a matter of fact, I'm sure I was not.

That's fine, I thought exactly the same when the recommendation was given to me. However, I then realised that the first time round I hadn't used the msi. When you use this there is a point when you get a dialog box up with a tree view in it, all nodes collapsed.

Expanding the extensions (or maybe extras) node gives access to these options such as gd, mqsql etc. In fact if you used the msi initially try the program repair option from control panel -> Programs and Features then right click on PHP and select change. You will then see the dialogue box I'm talking about, as lopng as the msi is still on your machine.

Cheers
nathj

[Frank Lopes]

Did exactly as you recommended with no success...

Any other ideas from anyone?

That's fine, I thought exactly the same when the recommendation was given to me. However, I then realised that the first time round I hadn't used the msi. When you use this there is a point when you get a dialog box up with a tree view in it, all nodes collapsed.

Expanding the extensions (or maybe extras) node gives access to these options such as gd, mqsql etc. In fact if you used the msi initially try the program repair option from control panel -> Programs and Features then right click on PHP and select change. You will then see the dialogue box I'm talking about, as lopng as the msi is still on your machine.

Cheers
nathj