这是一个创建于 1048 天前的主题，其中的信息可能已经有所发展或是发生改变。
Starting MySQL
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-3.local.pid).
xxxxx@MacBook-Pro-3 ~ % brew services info mysql
mysql (homebrew.mxcl.mysql)
Running:
Loaded:
Schedulable:
User: root
PID: 598
xxxxx@MacBook-Pro-3 ~ % 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)
xxxxx@MacBook-Pro-3 ~ % 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)
chengpeng@MacBook-Pro-3 ~ %
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!
. ERROR! The server quit without updating PID file (/usr/local/var/mysql/MacBook-Pro-3.local.pid).
xxxxx@MacBook-Pro-3 ~ % brew services info mysql
mysql (homebrew.mxcl.mysql)
Running:
Loaded:
Schedulable:
User: root
PID: 598
xxxxx@MacBook-Pro-3 ~ % 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)
xxxxx@MacBook-Pro-3 ~ % 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)
chengpeng@MacBook-Pro-3 ~ %
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!
 | 1 wu67 2023-02-15 16:03:00 +08:00 mac 配数据库建议 docker. 没这么多奇奇怪怪的问题. |
 | 2 silverdog OP xxx@MacBook-Pro-3 ~ % sudo mysql_secure_installation mysql_secure_installation: [Warning] World-writable config file '/etc/my.cnf' is ignored. Securing the MySQL server deployment. Enter password for user root: Error: Can't connect to local MySQL server through socket '/Users/xxxxx/Documents/mysql.sock' (2) xxxxx@MacBook-Pro-3 ~ % |
 | 3 julyclyde 2023-02-15 17:26:57 +08:00 Can't connect to local MySQL server through socket '/Users/xxxxx/Documents/mysql.sock' 客户端的某个神奇的配置文件说让它去连接这个根本不存在的地址 而服务器并没有监听在这个地址 |
 | 4 kongkx 2023-02-15 17:28:23 +08:00 via iPhone 卸载，清理配置文件，重新安装 |
 | 6 lululau 2023-02-15 17:30:37 +08:00 lnav /usr/local/var/mysql/*.err |
 | 8 Boos 2023-02-15 17:32:38 +08:00 真难啊 |
 | 9 Maboroshii 2023-02-15 17:34:59 +08:00 via Android 还是虚拟机 docker 吧，一劳永逸。 |
 | 10 liuhuansir 2023-02-15 18:05:27 +08:00 有了 docker 之后，我的笔记本干净多了，再也不需要折腾这些乱七八糟的事了 |
 | 11 lusi1990 2023-02-15 18:15:48 +08:00 我用这个命令启动: brew services start mysql 关闭: brew services stop mysql |
 | 12 liuzhaowei55 2023-02-15 18:17:41 +08:00 via iPhone DBngin 特别好用｛这条回复会花费我 26 铜币｝ |
 | 13 littlewing 2023-02-15 18:55:09 +08:00 你是不是以前装过 mysql 5.7 ? |
 | 14 Nazz 2023-02-15 22:32:14 +08:00 via Android 我 mac 上的 mysql 最近也挂了，然后换成了 mysql-community-server.dmg |
 | 15 toaruScar 2023-02-15 22:49:55 +08:00 via iPhone mysql: [Warning] World-writable config file '/etc/my.cnf' is ignored. 权限太宽了吧？ |
 | 16 jackytang520 2023-02-16 08:37:24 +08:00 via iPhone percona server 目前正常使用中 |
 | 17 vincent441 2023-02-16 09:04:34 +08:00 有 docker 启动 mysql 吧 |
 | 18 renjunv 2023-02-16 09:11:51 +08:00 和楼主同样的问题，各种卸载重装也都试过，目前还没解决 装过 mysql5.7 、8+，可能是升级版本后就开始启动不正常了 brew services run mysql 启动报错，重启电脑 brew 自动启动 mysql 可以成功 |
| 19 renjunv 2023-02-16 09:12:42 +08:00 出现这个问题的时候我的机器是 macos 12 |
Select Language