MySQL Error #2006

[gottasummer]

Hello,
I have done some searches, didnt find the answer really, just a bunch of people asking the same things, most of the threads are in the archive anyway.

So, I am getting error #2006, MySQL has gone away.

I have 0.6.3, and I do not know why this is happening, but I keep getting this error, I can login to mysql through the command line just fine, but it will not let me start up the server.

Please help.

Thanks.

[mattmeck]

means your DB isnt connecting, most times caused by a wrong user name or password, could also be "whitespace" in the fields, could be many other reasons dealing with the connection.

<<EDIT>>

Did a search for the exact name of your thread, many many threads in that search had answers.

FNW linked this in the second post (the one right under yours in the search by the way)

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

[gottasummer]

Ok.

I have also heard that MySQL 3.x works better and doesnt have this error, but the issue I am having is that MySQL 3.x setup refuses to run, I try to run the installer, it wont start up.
Am going to try getting the zip version of it to extract to C:\MySQL and will tell you how it works.

[gottasummer]

Ok, guys, I got it working!!!

I fixed it by doing the following:

Use mysql 4.0.23 instead of 4.1 or above... I suggest you do the same if you have this problem.

Will post in wiki as soon as someone fixes it.