0

Right now I do a netstat -n | grep 3306 and nothing come. Beside I try to connect using:

$ mysql -h127.0.0.1 -u root -p
Enter password: 
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)

to connect and see the error below. Even so, when I use:

$ mysql -hlocalhost -u root -p

no problem at all to connect to the server.

All this indicated me that MySQL Server installed the official installer on OS X 10.10 Yosemite, not allow networks connection to the server. How I enable that feature?

EDIT TO MAKE A POINT WY IS NOT A DUPLICATE QUESTION

Suggestions for solve this problem can be found in a lot of places like here, but none of those solutions worked for me. I will explain what I did, so MySQL on OS X gurus can suggest new things ;)

  1. I install MySQL following this guide

  2. Copy sample of my.cnf 

    sudo cp /usr/local/mysql/support-files/my-innodb-heavy-4G.cnf /etc/my.cnf

I can stop and start the service using the Figure 2.49 MySQL Preference

I tested without success:

From here:

Just comment out bind-address= altogether. When you do that, it will bind to all addresses. Also make sure that you don't have skip-networking enabled in your my.cnf.

I tested with bind-address comment out as well as skip-networking comment out. I tested with bind-address = 127.0.0.1 and with bind-address = 192.168.1.77 too.

I really don't what else to do. I'm testing that MySQL server is not listening to any TCP port using two commands:

  1. netstat -n | grep 3306, showing nothing.

  2. mysql -h 127.0.0.1 -u root -p and mysql -h 192.168.1.77 -u root -p, receiving Can't connect to MySQL server on... error

Any Help?

Community
  • 1

0 Answers0