mesqueeb mesqueeb - 4 months ago 11
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
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?

Answer

Often this is because of permissions, did you try?

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

sudo mysql.server start