MySQL Bugs: #1780: Persistent crashing

Bug #1780	Persistent crashing
Submitted:	7 Nov 2003 11:26	Modified:	8 Dec 2003 16:27
Reporter:	Andreas Kakanis-Silk	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQLCC	Severity:	S1 (Critical)
Version:	0.9.3	OS:	Windows (Windows 2000 Pro)
Assigned to:		CPU Architecture:	Any

Description:
I have installed MySQLcc as per instructions on Web. As soon as I try to connect to the server I get a Windows message box "mysqlcc.exe - Application error: The instruction at "0x39ee1141" referenced memory at "0x74093d09". The memory could not be read.
I have tried completely removing the program (via Control Panel) and re-installing, but get the same problem each time, though the instruction address and memory address are not always the same as the above (once it was 0x00000000 at 0x00000000).
I am trying to connect to a server on a Linux (Debian) box. I can run a Linux version of mySQLcc with no problems except it does not correctly display the Greek character set. I was hoping a windows version may solve this problem.

How to repeat:
Simple: it happens every time I try to connect.

I had a very similar problem. Same error message, running on win 2000 pro, connecting to a (RedHat) Linux mysql DB.

I managed to tie it down to the fact that the permissions were not set up correctly on the Linux database server (in the mysql.user table).
Once this was sorted out, mysqlcc connects and runs perfectly. 
If I delete the relevent record from the mysql.users table again, exactly the same things happens.

The mysql server refuses the connection on port 3306 if the user record isn't correct - in fact, even if you try to telnet onto port 3306, you simply get a "connection failed" message. mysqlcc just doesn't seem to handle this refused connection properly.

One thing to note: I was unable to use wildcards "%" in the host field of the mysql.users record for my windows 2000 remote client, I ended up puting the ip address of my win 2000 pc in the host field, and it all jumped into action then. (Don't forget to re-start the mysqld service after you update the mysql.users table).

Hope this helps!

OS Windows 98 Second Edition
mySQLcc version 0.9.3-win32

I think I had the 98 version of this. After some general exploration, I set up a database with 10 tables and tried to load in a datafile. I didn't like what I got so I deleted all the records. Then I got an abend message about an illegal operation. (I'll append the text of the error at the end.) From that point on, every time I tried to launch mySQLcc, I got the same error.

After reading this thread, I deleted the connection file I'd been messing with from c:\.mysqlcc\connections. That allowed me to launch mySQLcc and use the GUI to fix the problems with the user password. And the villagers danced for joy. :)

Thanks for pointing me in the right direction!

ej

Text of the error message --

MYSQLCC caused an invalid page fault in
module QT-MT312.DLL at 0167:39ee1141.
Registers:
EAX=0074f740 CS=0167 EIP=39ee1141 EFLGS=00010202
EBX=00000000 SS=016f ESP=0074f714 EBP=0074f724
ECX=00740053 DS=016f ESI=0074f730 FS=3b5f
EDX=0000003b ES=016f EDI=008750d0 GS=0000
Bytes at CS:EIP:
8b 11 ff 52 20 8b 45 08 5e 5d c2 08 00 55 8b ec 
Stack dump:
0074f738 0074f740 0074f730 004beddc 0074f748 004033d5 0074f738 0000003b 008f6310 008a7300 009085a0 00908410 0074f7c0 0074f7c0 00403305 0074f76c

Please verify if your case is the same of:

http://bugs.mysql.com/bug.php?id=1368

notice that you need to remove the files or the whole directory
called connections (mentioned there).

If yes please let us know for to mark this repost as duplicate.

Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html