mac Error: Failure while executing; `/bin/launchctl bootstrap gui/501
Database 2024/3/26 15:32:31 点击：不统计
<网f站o学a习s制p作.cn>
mac 升级brew后升级了mysql ，结果无法启动mysql 出现了
mac Error: Failure while executing; `/bin/launchctl bootstrap gui/501 /Users/username/Library/LaunchAgents/homebrew.mxcl.mysql.plist` exited with 5.
解决方法如下：
1. 查看 /Users/username/Library/LaunchAgents/homebrew.mxcl.mysql.plist 文件内容如下
<!DOCTYPE plist PUBLIC "-//Apple//DTD PLIST 1.0//EN" "http://www.apple.com/DTDs/PropertyList-1.0.dtd">
<plist version="1.0">
<dict>
<key>KeepAlive</key>
<true/>
<key>Label</key>
<string>homebrew.mxcl.mysql</string>
<key>LimitLoadToSessionType</key>
<array>
<string>Aqua</string>
<string>Background</string>
<string>LoginWindow</string>
<string>StandardIO</string>
<string>System</string>
</array>
<key>ProgramArguments</key>
<array>
<string>/usr/local/opt/mysql/bin/mysqld_safe</string>
<string>--datadir=/usr/local/var/mysql</string>
</array>
<key>RunAtLoad</key>
<true/>
<key>WorkingDirectory</key>
<string>/usr/local/var/mysql</string>
</dict>
</plist>
2.命令行运行：/usr/local/opt/mysql/bin/mysqld_safe
然后会提示错误文件地址：
2024-03-26T07:16:27.6NZ mysqld_safe Logging to '/usr/local/var/mysql/username.err'.
2024-03-26T07:16:27.6NZ mysqld_safe Starting mysqld daemon with databases from /usr/local/var/mysql
2024-03-26T07:16:32.6NZ mysqld_safe mysqld from pid file /usr/local/var/mysql/username.pid ended
3. 查看错误文件/usr/local/var/mysql/username.err （可以清空后再运行）内容提示为：
2024-03-26T07:16:27.716449Z 0 [Warning] [MY-010159] [Server] Setting lower_case_table_names=2 because file system for /usr/local/var/mysql/ is case insensitive
2024-03-26T07:16:28.048644Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 35
2024-03-26T07:16:28.212253Z 0 [ERROR] [MY-000067] [Server] unknown variable 'character-set-client-handshake=FALSE'.
2024-03-26T07:16:28.213076Z 0 [ERROR] [MY-010119] [Server] Aborting
2024-03-26T07:16:29.052402Z 1 [ERROR] [MY-012574] [InnoDB] Unable to lock ./ibdata1 error: 35
4.修正错误
（1）. 修改配置文件 lower_case_table_names=2
修改配置文件/usr/local/etc/my.cnf 新增上述配置（可以通过find 找到my.cnf）
（2）. 根据错误 去掉 'character-set-client-handshake=FALSE'.
然后再重新启动即可。
http://%77%77%77%2E%66网站制作%6F学习网%72%61%73%70%2E%63%6E