How to disable sql-mode STRICT_TRANS_TABLES

[samiuli]

Hi,

I need to disable sql-mode STRICT_TRANS_TABLES . But I can't disable it. How can I do that? My os is centos 8.

Thanks

 

[Zhenyapan]

set it in your mysql config file and restart mysql server/daemon

 

[samiuli]

set it in your mysql config file and restart mysql server/daemon

But how can I set?

Thanks

 

[Zhenyapan]

via SSH, connect as root or another user and upgrade then to root, then edit it via "mc" or "vi" or "nano"