Warning: putenv() has been disabled for security reasons in /www/wwwroot/wiki.xtboke.com/includes/Setup.php on line 309
http://wiki.xtboke.com/index.php?action=history&feed=atom&title=Windows_phpstudy_%E5%90%AF%E5%8A%A8_MySQL%E6%8A%A5%E9%94%99
Windows phpstudy 启动 MySQL报错 - 版本历史
2026-04-16T01:52:47Z
本wiki上该页面的版本历史
MediaWiki 1.41.1
http://wiki.xtboke.com/index.php?title=Windows_phpstudy_%E5%90%AF%E5%8A%A8_MySQL%E6%8A%A5%E9%94%99&diff=255&oldid=prev
Xiaotian：创建页面，内容为“==== Windows phpstudy 启动 MySQL报错 ==== 2020-12-23T02:17:31.813638Z 0 [ERROR] E:\phpstudy_pro\COM…\Extensions\MySQL5.7.26\bin\mysqld.exe: Error while setting value ‘STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION’ to ‘sql_mode’ 2020-12-23T02:17:31.813822Z 0 [ERROR] Aborting 2020-12-23T02:17:31.813844Z 0 [Note] Binlog end ==== 解决办法: ==== 根据报错提示路径找…”
2024-10-13T03:09:37Z
<p>创建页面，内容为“==== Windows phpstudy 启动 MySQL报错 ==== 2020-12-23T02:17:31.813638Z 0 [ERROR] E:\phpstudy_pro\COM…\Extensions\MySQL5.7.26\bin\mysqld.exe: Error while setting value ‘STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION’ to ‘sql_mode’ 2020-12-23T02:17:31.813822Z 0 [ERROR] Aborting 2020-12-23T02:17:31.813844Z 0 [Note] Binlog end ==== 解决办法: ==== 根据报错提示路径找…”</p>
<p><b>新页面</b></p><div>==== Windows phpstudy 启动 MySQL报错 ====<br />
2020-12-23T02:17:31.813638Z 0 [ERROR] E:\phpstudy_pro\COM…\Extensions\MySQL5.7.26\bin\mysqld.exe: Error while setting value ‘STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION’ to ‘sql_mode’<br />
2020-12-23T02:17:31.813822Z 0 [ERROR] Aborting<br />
2020-12-23T02:17:31.813844Z 0 [Note] Binlog end<br />
==== 解决办法: ====<br />
根据报错提示路径找到E:\phpstudy_pro\COM…\Extensions\MySQL5.7.26 my.ini文件<br />
打开文件找到sql_mode=这一行,删除逗号后面的空格,然后重启MySQL就可以了.</div>
Xiaotian