macOS 安装 MySQL
安装 MySQL
-
安装 MySQL
brew install mysql
-
启动 MySQL 服务
brew services start mysql
-
连接 MySQL
mysql -u root
Troubleshooting
出现 2002 错误无法连接 MySQL
mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
查看当前运行的服务发现没有 MySQL:
$ brew services list | grep mysql
mysql stopped user ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
尝试手动启动 MySQL,发现如下报错:The server quit without updating PID file (/opt/homebrew/var/mysql/MacBook-Pro.pid).
。但是经查验发现这个文件并不存在。
$ mysql.server start --verbose
Starting MySQL
. ERROR! The server quit without updating PID file (/opt/homebrew/var/mysql/MacBook-Pro.pid).
查看错误日志:
cat /opt/homebrew/var/mysql/MacBook-Pro.err | grep ERROR
我没有好的解决方法,只能删除 /opt/homebrew/var/mysql
目录并重新安装 MySQL:
rm -rf /opt/homebrew/var/mysql
brew reinstall mysql
brew start mysql
mysql -u root