. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-3.local.pid).
[email protected] ~ % brew services info mysql
mysql (homebrew.mxcl.mysql)
Running: ✔
Loaded: ✔
Schedulable: ✘
User: root
PID: 598
[email protected] ~ % mysql
mysql: [Warning] World-writable config file '/etc/my.cnf' is ignored.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/Users/xxxxx/Documents/mysql.sock' (2)
[email protected] ~ % mysql -u root
mysql: [Warning] World-writable config file '/etc/my.cnf' is ignored.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/Users/chengpeng/Documents/mysql.sock' (2)
[email protected] ~ %
macos 13
试了办法
brew remove mysql
brew cleanup
launchctl unload -w ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
rm ~/Library/LaunchAgents/homebrew.mxcl.mysql.plist
sudo rm -rf /usr/local/var/mysql
brew install mysql
mysqld --initialize --explicit_defaults_for_timestamp
mysql.server start # no sudo!
