macOS 安装 MySQL

安装 MySQL

  1. 安装 MySQL

    brew install mysql
    
  2. 启动 MySQL 服务

    brew services start mysql
    
  3. 连接 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
posted @ 2025-01-03 00:21  Undefined443  阅读(7)  评论(0编辑  收藏  举报