MySQL on IIS6

Butters · 18 Dec 2007 at 15:36

Chaps,

I asked the otherday if PHP/MySQL/phpmyadmin could be run on Win2K3 server running IIS. I've downloaded them all and got it working with one exception

When you log in to phpmyadmin it returns an error saying that MySQL cannot connect to the localhost. I would assume this is for two reasons:

1)Exchange is running
2)Windows internal database is running

I remember from previous MySQL installers that you used to be given the choice of which host MySQL would use and the default was 'localhost'.

Well in MySQL 5, no such option existed.

Basically, where can one alter the host so I can change it from localhost to one of the host headers?

Butters · 18 Dec 2007 at 16:56

Yeah, seems to be when I run from the command client

Butters · 18 Dec 2007 at 18:01

username and password are both root

The problem comes when phpmyadmin connects it says its not allowed to connect to myinternalserver.domain.com (basically, localhost). Which is fine as I dont want it to.

I want it to connect to myhostheaderserver.domain.com, which, although also using port 80 is defined with a host header.

Butters · 18 Dec 2007 at 18:11

no, thanks. do you happen to have a link or a best version to recommend?

Butters · 18 Dec 2007 at 20:15

Cool, thanks

EDIT: It says I the service cant start but there is nothing in the Error logs

Any ideas?

Butters · 19 Dec 2007 at 10:59

Got it working now. Thanks

Butters · 19 Dec 2007 at 14:16

I re-installed MsSQL5 and then re-started the service and it worked.

Other than that, I'm not too sure.