这是一个创建于 676 天前的主题，其中的信息可能已经有所发展或是发生改变。
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