V2EX = way to explore
V2EX 是一个关于分享和探索的地方
Sign Up Now
For Existing Member Sign In
• 请不要在回答技术问题时复制粘贴 AI 生成的内容
This topic created in 1179 days ago, the information mentioned may be changed or developed.
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 Feb 15, 2023
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 Feb 15, 2023
Can't connect to local MySQL server through socket '/Users/xxxxx/Documents/mysql.sock'
客户端的某个神奇的配置文件说让它去连接这个根本不存在的地址 而服务器并没有监听在这个地址 |
 |
4
kongkx Feb 15, 2023 via iPhone
卸载，清理配置文件，重新安装
|
 |
6
lululau Feb 15, 2023
lnav /usr/local/var/mysql/*.err
|
 |
8
Boos Feb 15, 2023
真难啊
|
 |
9
Maboroshii Feb 15, 2023 via Android
还是虚拟机 docker 吧，一劳永逸。
|
 |
10
liuhuansir Feb 15, 2023
有了 docker 之后，我的笔记本干净多了，再也不需要折腾这些乱七八糟的事了
|
 |
11
lusi1990 Feb 15, 2023
我用这个命令启动:
brew services start mysql 关闭: brew services stop mysql |
 |
12
liuzhaowei55 Feb 15, 2023 via iPhone
DBngin 特别好用｛这条回复会花费我 26 铜币｝
|
 |
13
littlewing Feb 15, 2023
你是不是以前装过 mysql 5.7 ?
|
 |
14
Nazz Feb 15, 2023 via Android
我 mac 上的 mysql 最近也挂了，然后换成了 mysql-community-server.dmg
|
 |
15
toaruScar Feb 15, 2023 via iPhone
mysql: [Warning] World-writable config file '/etc/my.cnf' is ignored.
权限太宽了吧？ |
 |
16
jackytang520 Feb 16, 2023 via iPhone
percona server 目前正常使用中
|
 |
17
vincent441 Feb 16, 2023
有 docker 启动 mysql 吧
|
 |
18
renjunv Feb 16, 2023
和楼主同样的问题，各种卸载重装也都试过，目前还没解决
装过 mysql5.7 、8+，可能是升级版本后就开始启动不正常了 brew services run mysql 启动报错，重启电脑 brew 自动启动 mysql 可以成功 |
|
19
renjunv Feb 16, 2023
出现这个问题的时候我的机器是 macos 12
|
Select Language