CODEWITHSUNDEEP
mysqlhomebrew
user27111987
user27111987

Reputation: 1085

brew services list shows mysql running but cannot connect

I followed instructions on installing mysql using brew from here https://gist.github.com/nrollr/3f57fc15ded7dddddcc4e82fe137b58e

brew services list shows below output

Name  Status  User         Plist
mysql started <username> /Users/<username>/Library/LaunchAgents/homebrew.mxcl.mysql.plist

But when I run 'mysql' or 'mysqladmin -u root password '' I get error.

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

Can anybody tell the issue here.

Upvotes: 9

Views: 17618

Answers (1)

Damian Dziaduch
Damian Dziaduch

Reputation: 2127

What is your MySQL version? Recently MySQL v8 was released and it is causing problems.

I suggest to first stop the MySQL service via brew services stop mysql and then uninstall MySQL via brew uninstall mysql.

Next, please remove its data folder by executing rm -rf /usr/local/var/mysql.

After that please do brew upgrade.

If you want to install MySQL v5.7 just do

brew install [email protected] && brew link --force [email protected] && brew services start [email protected]

This also works for [email protected] and [email protected].

Upvotes: 27

Related Questions