- 积分
- 16
- 威望
-
- 金钱
-
- 注册时间
- 2017-3-3
- 在线时间
- 小时
- 最后登录
- 1970-1-1
|
军哥:
我装lamp1.4, mysql 5.7,现我要安装ilias,它有个要求, sudo nano /etc/mysql/conf.d/disable_strict_mode.cnf, 可我找不到这个目录去加这个文件,我应加到哪个文件夹下?谢谢!
下面为参考信息:
IMPORTANT NOTICE: With MySQL 5.6 and above, MySQL activates the options STRICT_TRANS_TABLES and STRICT_ALL_TABLES by default. Please deactivate, e.g.: https://serverpilot.io/community/articles/how-to-disable-strict-mode-in-mysql-5-7.html
[size=1.2]To disable strict SQL mode, SSH in to your server as root and create a new configuration file using nano or the editor of your choice:
sudo nano /etc/mysql/conf.d/disable_strict_mode.cnf[size=1.2]In the file, enter these two lines:
[mysqld]sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CR |
|