MySQL Bugs: #3677: Mysql and Windows server 2003

Bug #3677	Mysql and Windows server 2003
Submitted:	6 May 2004 16:40	Modified:	13 Jul 2004 20:52
Reporter:	Elgivio HASAMA	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Installing	Severity:	S2 (Serious)
Version:		OS:	Windows (Windows 2003 SERVER)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
I have the following error when I execute winmysqladmin.exe after first installation process: "access violation at address 0040289D in module 'winmysqladmin.exe'. Read of address 00000000."
I don't know if it is due to mysql or windows server 2003. I try version 3.23.44, 3.23.47 and 4.0 and have the same error. 

How to repeat:
Anytime I excute winmysqladmin.exe

Without to use the WinMySQLAdmin are you able for to run the
MySQL server from a prompt command screen like: ?

c:\mysql\bin>mysqld-nt --standalone --console

Yes It's working from a prompt command screen like c:\mysql\bin>mysqld-nt --standalone --console.

It's working properly on windows server 2000 and on windows NT 4.0 with using winmysqladmin.exe.

I also get this problem with WIn2003 server Ent Edition.
It's really frustrating as i've searched the web and cannot find a solution.

Hello
I recently installed Win 2003 Server Ent edition and I got php to work fine but winmysqladmin is giving this exact problem. I am not able to have my php scripts work when connecting to the db - it cannot connect.
Anyone know of any patch to fix this ?
Anjanesh

I have noticed that when you have 2003 server as a PDC the Service wont stay running, if this is your case look in your lodon profile in the Windows folder and you will fing the .ini files, it seems that some progs arnt saving the .ini files to the %system% folder and are saving them to your profile folder in Windows in stead. As was my case with any ver of MySQL.

I was able to copy the .ini files to the %system% folder and reboot and the service will now run.

I hope this helps with your prob and any others.

Hi,

I wasn't able for to repeat the behavior reported on my Windows 2003
Server. So I need more information regarding your environment.

Thanks.

I keep getting the same error message when I installed mysql on windows 2003 server.
' access violation at address 0040289D in module 'winmysqladmin.exe' 

please help

I had the same problem. and this is how I resolved it. remove mysql from your computer. MySQL reads it's configuration directives from a text file called my.ini. This file should be placed in the main Windows folder which will be /WINNT on Windows NT/2000 and /WINDOWS on Windows 98/XP/2003.Now let's see what should your my.ini file look like? Create a new my.ini file in your Windows installation folder and copy/paste following text in it.

[client]
port=3306

[mysqld]
port=3306
enable-named-pipe
socket=MySQL

skip-locking
set-variable	= max_connections=64
set-variable	= read_buffer_size=1M
set-variable	= key_buffer=8M
set-variable	= max_allowed_packet=1M
set-variable	= table_cache=64
set-variable	= sort_buffer=512K
set-variable	= net_buffer_length=8K
set-variable	= myisam_sort_buffer_size=4M
server-id	= 1

basedir = D:/mysql-4.0.14b-win-noinstall/
datadir = D:/mysql-4.0.14b-win-noinstall/data/

skip-bdb

innodb_data_file_path = ibdata1:10M:autoextend
set-variable = innodb_buffer_pool_size=32M
set-variable = innodb_additional_mem_pool_size=4M

set-variable = innodb_log_file_size=8M
set-variable = innodb_log_buffer_size=8M

innodb_flush_log_at_trx_commit=1

[mysqldump]
quick
set-variable	= max_allowed_packet=8M

[mysql]
no-auto-rehash

[isamchk]
set-variable	= key_buffer=10M
set-variable	= sort_buffer=10M
set-variable	= read_buffer=2M
set-variable	= write_buffer=2M

[myisamchk]
set-variable	= key_buffer=10M
set-variable	= sort_buffer=10M
set-variable	= read_buffer=2M
set-variable	= write_buffer=2M

[mysqlhotcopy]
interactive-timeout

The my.ini file should at least contain the path to the MySQL installation and data files folder. Since I am assuming you installed MySQL in D:\mysql-4.0.14b-win-noinstall folder, this folder's path has been put in my.ini file.

after you created my.ini file, then install mysql. It worked for me

Good Luck

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!