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

2
votes

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?

1
mysqlsocketshomebrew
Did you start the mysql server? – user4398985
Yes I did. mysql.server start – mesqueeb
@ShivaShinde When I try to check the existance of the socket file: ls -al /tmp/mysql.sock It says: No such file or directory. – mesqueeb
Could you check whether your /etc/my.cnf or /etc/mysql/my.cnf has socket defindd in the below manner? [client] socket=/var/lib/mysql/mysql.sock – user4398985
Tried looking for both files. Again, they do not exist. Maybe brew install mysql didn't work properly? Did it forget to install certain files you think? – mesqueeb

1 Answers

5
votes

Often this is because of permissions, did you try?

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

sudo mysql.server start