MySQL on Windows Server

haggul · 13-05-08

I have MySQL running on IIS6 - it refuses to take any connections when started up as a normal service. It just hangs up and does nothing.

When I start with the --console switch from a command line it seems to work and allows me to connect and browse data using local GUI tools (SQLYog) on the server itself.

I am thinking it's some sort of permissions / security type issue but can't figure it out at all.

I have tried MySQL reinstall but even trying different builds I am having the same issues. I have also had issues with the install from the Essentials install files (tried 2 different builds) in that it hangs on the APply Security Settings bit at the end.

If not permissions I was wondering if there is some hangover I need to clear out from previous install?

Any ideas?!

Chris.

ep90 · 13-05-08

Are you blocking the port with your firewall? As default this is TCP 3306.

accelerator · 13-05-08

Just a real guess here but try looking at the Windows services side of things, i.e. have a look at how MySQL is running as a service and what permissions level it has there.