mesqueeb mesqueeb - 1 year ago 79
SQL Question

MySQL (mysql_secure_installation) won't work after installing through homebrew: Can't connect through socket

When just installing mysql on OSX through homebrew like so:

brew install mysql
and I try to run the command
as brew suggests, it just gives me the following error:

Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

I tried ALL SOLUTIONS from this thread: Can't connect to local MySQL server through socket homebrew

But alass nothing solved my problem. Any advice to debug?

When I try to check the existance of the socket file:

ls -al /tmp/mysql.sock

It says: No such file or directory.

Did Homebrew maybe forget to install something?

Answer Source

Often this is because of permissions, did you try?

sudo chown -R _mysql:mysql /usr/local/var/mysql

sudo mysql.server start
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download