brew服务列表显示mysql正在运行，但无法连接 [英] brew services list shows mysql running but cannot connect

问题描述

我从这里按照有关使用brew安装mysql的说明进行操作 https://gist.github.com/nrollr/3f57fc15ded7dddddcc4e82fe137b58e

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

但是当我运行'mysql'或'mysqladmin -u root password''时，我得到了错误.

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.

推荐答案

您的MySQL版本是什么?最近发布了MySQL v8，它引起了问题.

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

我建议首先通过brew services stop mysql停止MySQL服务，然后通过brew uninstall mysql卸载MySQL.

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

下一步，请通过执行rm -rf /usr/local/var/mysql删除其数据文件夹.

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

之后，请执行brew upgrade.

如果要安装MySQL v5.7，只需执行

If you want to install MySQL v5.7 just do

brew install mysql@5.7 && brew link --force mysql@5.7 && brew services start mysql@5.7

这也适用于mysql@5.6和mysql@5.5.

这篇关于brew服务列表显示mysql正在运行，但无法连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！