MySQL Bugs: #3488: Winmysqladmin error.

Bug #3488	Winmysqladmin error.
Submitted:	16 Apr 2004 20:08	Modified:	16 Aug 2004 19:08
Reporter:	Asim Saghir	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.0	OS:	Windows (Windows Server 2003)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
I installed mysql the very first time on my other computer with 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.
---

Then instead of taking me to the username and password dialog (where you choose your username and password, since i havent chosen one yet.) it takes me to the main screen with a red light, and nothing except my computer name is filled in...

How to repeat:
winmysqladmin.exe doesnt work, which means mysql won't work..

The kind of error happens when the tool doesn't find TCP/IP support
on the Operational System.

Could you please test if you are able for to start the server with:

mysqld-nt --standalone --console

opening a prompt console screen and going to \mysql\bin directory.
If the server fails to start please show us the message printed.

Thanks

Oh....Are you saying this won't work without TCP/IP ? At the time of Win 2003 server intallation, I chose not to install File/Printer Sharing, TCP/IP etc etc since I'm not having a computer in a network. So I thought why install the networking stuff. Is it because of this ? If so please let me know because I have gone back to WinMe just for this reason.
Thanks

Yes WinMySQLAdmin needs the TCP/IP support. However you are
able for to run the MySQL server without TCP/IP but in this
case you need to enable the named pipes for to work locally.

Then in your %windir%\my.ini file under section [mysqld]
add the below keys:

[mysqld]
skip-networking
enable-named-pipe

Then in this case the server shows the below messages when
started:

C:\mysql\bin>mysqld-nt --standalone --console
040530  0:56:25  InnoDB: Started
mysqld-nt: ready for connections.
Version: '4.0.20a-nt'  socket: ''  port: 0

notice: socket: ''  port: 0

so for a client to connect needs to use the named pipe
option called MySQL.

For to start and stop the server you can install the
service with:

mysqld-nt --install or mysqld-nt --install-manual

I can't to fix the crash of that tool when the TCP/IP support
doesn't exist, because the language applicaction which
was built doesn't permits to control the TCP/IP load at
the start.

WinMySQLAdmin running on Windows 2003 server

Attachment: winmysqladmin-on-win2003.JPG (image/jpeg, text), 122.14 KiB.

I tested WinMySQLAdmin on my Windows 2003 server box and wasn't
able to repeat the behavior reported. Please see the picture attached
to this bug report using the Files tab.

Hi, 

I think I found a solution. (at least for my case)

My specs are Win Server 2003 and Mysql ver 3.23.52

---------Solution--------------------------

On Network Connection window,
Right Click on your LAN connection and choose Properties

Then press button "Install...">>Protocol>>Microsoft TCP/IP version 6

and then click "Add..."

Close the properties window

now open WinMySQLAdmin.exe

no error!