MySQL on IIS6

Butters

Butters

Butters

Permabanned
Joined
22 Apr 2007
Posts
1,805
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?
 
can you confirm mysql is running ok?

edit: just to add... do you have any particular reason for using phpmyadmin? i assume this server is on a local network to you? download and use the mysql administrator application instead.
 
Last edited:
What username are you using to log in with? root?

Have you tried mySQL query browser? Much safer than phpmyadmin.

Your suggestions as to why it wont work are not issues. mySQL uses port 3306, Exchange uses many ports, none of which are 3306 and unless you have installed SQL server or MSDE, there is no 'Windows Database' that runs (and none of those mentioned use the same port as mySQL either).

They likely reason is to be with assigning the correct permissions and what host the specified user can connect from etc...
 
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.
 
Have you installed mySQL Administrator? From here it is very easy to assign hosts from which users can login from.
 
Butters said:
Cool, thanks

EDIT: It says I the service cant start but there is nothing in the Error logs :( Any ideas?
Click to expand...

Try reinstalling mySQL?

brendy said:
Has anyone had any bother with wamp5 running on a 2003 sbs server premium, while running a sql database?
Basically one of our customers had to get their server rebuilt due to a 3rd party trying to install it onto one of our servers, they came across errors on start up then when they uninstalled it the server stated the sbscore routine, finding a second domain controller and shutting down. Something really strange had happened and the server was possibly seeing itself as a second server and doing the shutdown routine, really wierd.
Click to expand...

Please start a new thread. Asking this will just clog up this thread and it will get derailed from what the OP is asking.
 
You must log in or register to reply here.
Back
Top Bottom