discussion How to disable strict_trans_tables at MariaDB Almalinux and DirectAdmin?

[Aior]

When I install a script that's what I see:

The sql-mode strict_trans_tables is enabled in your mysql server, please contact your host provider to disable it.

Connect your SSH as root user,

nano /etc/my.cnf

Add the code below and then Ctrl + X to save ---> y + Enter

sql_mode="ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Then Restart MariaDB from DirectAdmin Service Monitor Panel



Thats all!