MySQL Forums
Forum List  »  MySQL Workbench

Re: Lost Connection to MySQL
Posted by: West Dude
Date: February 25, 2010 11:51AM

Ok. I'm going to answer my own question then so that other people who may stumble around this same issue can resolve it.

somehow in my.cnf I added a line bind-address = ip address of the server which somehow cause mysql to refuse and drop the packet connection to the server because the binding address is different than how I'm going to connect to the server which is localhost.

So I changed the bind-address=localhost , restart mysql and that solved the problem.
Here is the link reference on how I figured it out.,151255,156258#msg-156258

funny how you always solve the problem yourself after you start asking people how to do it even though you've been banging on your head for couple of days wondering what the heck is going on. :-)

Options: ReplyQuote

Written By
February 25, 2010 11:37AM
Re: Lost Connection to MySQL
February 25, 2010 11:51AM
March 02, 2010 01:52AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.