文件夹询问:/etc/mysql/conf.d/disable_strict_mode.cnf
军哥:我装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
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.cnfIn the file, enter these two lines:
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CR 没有这个目录和文件,直接在 /etc/my.cnf 中添加
页:
[1]