How to disable strict_trans_tables at MariaDB Almalinux and DirectAdmin?

aior

Administrator
Staff member
Joined
Apr 2, 2023
Messages
68
Reaction score
0
Points
6
Age
38
Location
Turkey
Website
aior.com
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.

1708010057254.jpeg

Connect your SSH as root user,

Code:
nano /etc/my.cnf

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

Code:
sql_mode="ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

Then Restart MariaDB from DirectAdmin Service Monitor Panel

1708011011876.jpeg

Thats all!
 
Top