Page 1 of 1

winmyadmin does not work in windows 2003 server (ent or std)

Posted: Sat May 29, 2004 2:09 am
by anjanesh
Hello
I installed MySQL 4 on Windows Server 2003, and I get this error when I run winmysqladmin.exe

Access violation at address 0040289D in module 'winmysqladmin.exe'. Read of address 00000000.

If I type mysqld-nt in the command prompt it works and then I can run mysql. But then my PHP scripts won't access mysql db though it did when I was running it in WinMe.

Thanks a lot for any help

Posted: Mon Jun 14, 2004 2:22 pm
by anjanesh
This is resolved
SOLVED

Posted: Mon Jun 14, 2004 2:23 pm
by magicrobotmonkey
for future reference... how?

Posted: Mon Jun 14, 2004 3:42 pm
by anjanesh
Somehow (???) Win2k3 Server does not seem to configure tcp/ip unless you actually are connected to a lan or internet. So if you are running Win2k3 server on a single machine then just try setting a network connection adn then run the scripts (mysql actually) again. I'm not so sure if this is the right answer but in my case my system's ethernet card was already connected to the cable modem but I did not switch it on since there was no internet connection from my ISP that time. But when I did switch it on, even though there was no net and hence no ip address mysql (or windows) thought that the network cable is unplugged but connected. So I guess its the networking part. MySQL clearly mentions in its docs that it requires tcp/ip connection and for servers named pipes is an alternative. For non server version windows tcp/ip acts as localhost as default but this does not seem to happen in Win 2003 server.
Using named pipes in 2k & 2k3 : I don't know how this works but its given in http://dev.mysql.com/doc/mysql/en/Windo ... erver.html
I hope this was helpful.