[nommiiss]

I need to run MySQL and PHP on my IIS web server.

I am running a Windows 2003 enterprise server running IIS6 PhP 5 and MySQL 5 (i think. I downloaded it about 2 weeks ago date: 15.04.2005)

I have gotten PhP working with with IIS not a problem but seem to be getting problems connection from php/IIS to MySQL database.

I need to run IIS becuase I run Exchange server to run OWA. (I only have one server to make things work and yes it runs like a mule seen as its only a p3 733mHz)

can anyone help me resolve this problem am getting....I am thinking there is a config file that I am missing or somthing todo with PHP. I run the mysql setup as default and have insalled MySQL Admin and created databases.

Let me know if anyone knows how to fix this problem

THanks

Simon

[blaw]

Hello,

I think you need to be a little more specific on the subject. What kind of error messages, if any, are you getting, what is the symptom that made you think that it was not working, etc?

I am not very familiar with IIS, but given that you are using PHP 5 and having a problem with MySQL, you might want to check this out, especially if you are getting "function undefined" error:

http://jp2.php.net/manual/en/faq.dat...ses.mysql.php5

HTH.

[bizzar528]

did you start the mysql service?

[<?Wille?>]

did you enable mysql extension in php.ini
mysql is not enabled by default since php5 (was in previous versions) so few steps how to

open php.ini in eg notepad (located in c:\windows\system32\)
*Ctrl+f* or edit->find and type "mysql"
this should bring you to a line that is:
;extension=php_mysql.dll
enable that extension by removing the semicolon ( ; )

restart IIS, START->administrative tools->services | right click IIS -> restart

if the problem was the extension it should be fixed with this

regards

[nommiiss]

I have not changed anything in the php.ini I will have a look at that now.

Thanks

[z_zz]

hi nommiiss, have you solved your problem? I am trying to do the same, linking PHP 5.0.4 up with MySQL 4.1.11, and no success thus far. I've installed PHP as an IIS module via ISAPI and verified that both PHP and MySQL are working fine. Could you or anyone please let me know the way if you have benn able to make the connection? Thanks.

[Sheepymot]

We really need a specific error. I got one about "Client doesn't support authentiaction method" and remedied it by disabling a setting in the MySQL Administrator.