打印

文件夹询问:/etc/mysql/conf.d/disable_strict_mode.cnf

文件夹询问:/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
[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

TOP

没有这个目录和文件,直接在 /etc/my.cnf 中添加

TOP