[SOLVED] winmyadmin does not work in windows 2003 server (en

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

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

Post 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
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post by anjanesh »

This is resolved
SOLVED
magicrobotmonkey
Forum Regular
Posts: 888
Joined: Sun Mar 21, 2004 1:09 pm
Location: Cambridge, MA

Post by magicrobotmonkey »

for future reference... how?
User avatar
anjanesh
DevNet Resident
Posts: 1679
Joined: Sat Dec 06, 2003 9:52 pm
Location: Mumbai, India

Post 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.
Post Reply