Tuesday, November 30, 2010

MySQL Workbench XAMPP system error: 61

Here comes another one!
Today the Workbench threw this in my face:
Lost connection to MySQL server at 'reading initial communication packet', system error: 61
It seems that XAMPP is really serious about security. Kinda odd considering that everybody uses it for development and not production...
So it comes with the skip-networking option enabled by default :p
That doesn't bother php but it does break the MyQL Workbench. So you need to disable it. In Terminal:
vi /Applications/XAMPP/etc/my.cnf
Arrow down to the line after [mysqld] that says
skip-networking
and put a # in front so it looks like
#skip-networking
use the XAMPP panel to stop and start MySQL again.
Now the MySQL Workbench should connect fine to localhost.

Note: I did not need to add
bind-address=127.0.0.1
but if the above fails for you then put that in also.
Maybe it'll work.

2 Comments:

Blogger ShaqDonalds said...

Thank you very much! I was getting mad that my MySQL Workbench wasn't connecting and this did the trick! You have saved me many hours.

Thanks again.

4:00 AM, February 21, 2011  
Anonymous Anonymous said...

Ha! I needed this!
But why o why does it bug Query Browser and doesn't it bug PHP ? Does PHP secretly use a local pipe when we want localhost?
Or is it something outside my understaning scope?

11:38 PM, March 20, 2011  

Post a Comment

Links to this post:

Create a Link

<< Home