mac brew 安装 mysql8 无法启动

[silverdog]

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!

[wu67]

mac 配数据库建议 docker. 没这么多奇奇怪怪的问题.

[silverdog]

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 ~ %

[julyclyde]

Can't connect to local MySQL server through socket '/Users/xxxxx/Documents/mysql.sock'
客户端的某个神奇的配置文件说让它去连接这个根本不存在的地址

而服务器并没有监听在这个地址

[kongkx]

卸载，清理配置文件，重新安装

[silverdog]

@julyclyde brew 又启动不了了

[lululau]

lnav /usr/local/var/mysql/*.err

[silverdog]

@kongkx 卸载过无数次，重启过无数次，方法都用过

[Boos]

真难啊

[Maboroshii]

还是虚拟机 docker 吧，一劳永逸。

[liuhuansir]

有了 docker 之后，我的笔记本干净多了，再也不需要折腾这些乱七八糟的事了

[lusi1990]

我用这个命令启动:
brew services start mysql
关闭:
brew services stop mysql

[liuzhaowei55]

DBngin 特别好用｛这条回复会花费我 26 铜币｝

[littlewing]

你是不是以前装过 mysql 5.7 ?

[Nazz]

我 mac 上的 mysql 最近也挂了，然后换成了 mysql-community-server.dmg

[toaruScar]

mysql: [Warning] World-writable config file '/etc/my.cnf' is ignored.
权限太宽了吧？

[jackytang520]

percona server 目前正常使用中

[vincent441]

有 docker 启动 mysql 吧

[renjunv]

和楼主同样的问题，各种卸载重装也都试过，目前还没解决
装过 mysql5.7 、8+，可能是升级版本后就开始启动不正常了
brew services run mysql 启动报错，重启电脑 brew 自动启动 mysql 可以成功

[renjunv]

出现这个问题的时候我的机器是 macos 12

[julyclyde]

@intkilow 并没有“又”
你那个从来就启动不了

你先搞明白 mysql 的配置文件咋回事再说 brew 的事

[silverdog]

@julyclyde 有时能起来但是停止不了，brew 显示停止后还能链接 mysql,目前不知道怎么回事

[julyclyde]

@intkilow 那说明你连接到那个不是从 brew 启动的而是从别处启动的