Help me turn off 'strict_trans_tables' on CyberPanel

hiepbavi · August 22, 2023, 3:18pm

I am installing Wowonder and encountering this message - ‘The sql-mode strict_trans_tables is enabled in your MySQL server, please contact your host provider to disable it.’ Please help me with instructions on where to disable strict_trans_tables. I’ve searched on forums and Google, but I haven’t found any guidance.

flextypesite · August 22, 2023, 7:35pm

gist.github.com

https://gist.github.com/yidas/b27cb8c08303a5d8d856f2abb1618afb

mysql-change-sqlmode.md

## [MySQL] Permanently change SQL Mode in MySQL (disable_strict_mode)

Set into `[mysqld]` of MySQL config, for Ubuntu your could create a file `/etc/mysql/conf.d/disable_strict_mode.cnf`:

```
[mysqld]
sql_mode=NO_ENGINE_SUBSTITUTION
```

> SQL mode example: `STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION`

This file has been truncated. show original