CODEWITHSUNDEEP
mysqlsocketshomebrew
mesqueeb
mesqueeb

Reputation: 6324

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 mysql_secure_installation 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?

Upvotes: 4

Views: 4512

Answers (1)

user4398985
user4398985

Reputation:

Often this is because of permissions, did you try?

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

sudo mysql.server start

Upvotes: 6

Related Questions