Mac（M3/Sequoia）原生包安装MySQL启动异常及配置问题求助

我的环境 #

• MacBook Pro M3
• Sequoia系统

已执行操作 #

1. 通过原生安装包完成MySQL安装
2. 通过GUI工具修改配置文件，配置界面如下：
   
   配置内容：

[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION

3. 点击应用配置

遇到的问题 #

• MySQL实例启动后立即关闭
• 指定错误日志/usr/local/mysql/data/mysqld.local.err未显示异常启动失败信息，日志内容如下：

sudo cat /usr/local/mysql/data/mysqld.local.err
2025-04-03T05:11:13.596784Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 9.2.0).
2025-04-03T05:11:15.600786Z 0 [Warning] [MY-010909] [Server] /usr/local/mysql/bin/mysqld: Forcing close of thread 3133  user: 'root'.
2025-04-03T05:11:15.600922Z 0 [Warning] [MY-010909] [Server] /usr/local/mysql/bin/mysqld: Forcing close of thread 2471  user: 'root'.
2025-04-03T05:11:16.181595Z 0 [System] [MY-010910] [Server] /usr/local/mysql/bin/mysqld: Shutdown complete (mysqld 9.2.0)  MySQL Community Server - GPL.
2025-04-03T05:11:16.181614Z 0 [System] [MY-015016] [Server] MySQL Server - end.

待解答疑问 #

• MySQL实例为何启动后立即关闭？
• 还可通过哪些路径查看相关日志？
• 如何正确配置sql_mode = "NO_ENGINE_SUBSTITUTION"？

内容的提问来源于stack exchange，提问作者Jerry