PHPStudyMysql 报错 Error while setting value 'NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION' to 'sql_mode' [ERROR] Aborting
super
2023-02-17 14:53
![views](/static/super/images/icon/evaluate-9a.png)
2023-02-17T02:35:43.666026Z 0 [ERROR] E:\soft\PHPStudy\Install\COM\..\Extensions\MySQL5.7.26\\bin\mysqld.exe: Error while setting value 'NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION' to 'sql_mode'
2023-02-17T02:35:43.666092Z 0 [ERROR] Aborting
MySQL无法启动
![](/uploads/article/20230217/9699e2b46d091410c094637e36838e54.png)
搜索 sql_mode
![](/uploads/article/20230217/cbf742e942ff1577abc4a4f7d3ff29fe.png)
把中间多余的空格删掉,只要是sql_mode这行,把空格都删掉
![](/uploads/article/20230217/61cafadd14d7e7486f3fa33986f1aeee.png)
0 条讨论