SOLVED Disable MySQL strict mode - CloudLinux + MySQL 5.7

[Galcea]

Hello,

I have a problem with the STRICT_TRANS_TABLES and i want to disable it.
I tried some fixed from this threds: Disable MySQL Strict Mode and Strict Mode Thred

sql_mode=""

sql_mode=NO_ENGINE_SUBSTITUTION

sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

After all of this when i test with mysql -e 'select @@GLOBAL.sql_mode;' i get

+-------------------------------------------------------------------------------------------------------------------------------------------+
| @@GLOBAL.sql_mode                                                                                                                         |
+-------------------------------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
+-------------------------------------------------------------------------------------------------------------------------------------------+

Also i updated the etc folder like Ignor sugested
cagefsctl --update-etc (like Igor sugested): CageFS and my.cnf
Nothing

Do you have eany other sugestions? I can't figure it out.

I use:
CLOUDLINUX 7.6 [c] v82.0.11 with PHP Governor
mysql Ver 14.14 Distrib 5.7.27,

 

[Michaelit]

Hello to all,
i try to change the sql_mode to NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER however i see no change once i restart mysqld and even the whole server! I attach the file: my.cnf file and a print screen from phpmyadmin.

Please guide me!

 

[cPanelMichael]

Hello

I've been unable to reproduce this issue on a test environment. Could either of you share any errors seen in the output from the following command after restarting MySQL?

tail -50 /var/log/mysqld.log

Note: The MySQL error log can sometimes include identifying information about your server or database names. Ensure to scan any error output thoroughly before pasting it here in CODE tags.

I have a problem with the STRICT_TRANS_TABLES and i want to disable it.

Can you share the specific issue you were facing with STRICT_TRANS_TABLES?

Note, I recommend reading more about how this MySQL configuration value is defined on the following MySQL document and StackOverflow thread:

MySQL :: MySQL 5.7 Reference Manual :: 5.1.10 Server SQL Modes

dev.mysql.com

Error related to only_full_group_by when executing a query in MySql

I have upgraded my system and have installed MySql 5.7.9 with php for a web application I am working on. I have a query that is dynamically created, and when run in older versions of MySQL it works...

stackoverflow.com

Thank you.

 

[Michaelit]

Hello @cPanelMichael,
It's really weird! Sorry for this late response. I finally completed that request through phpmyadmin tool as a root. I really don't know why that happened.
Although days have passed, i don't know if my mysqld.log file could help find out the reason.

I attach the log file however as i see it's the same notice again and again!

 

[Michaelit]

Unfortunately this is a temporarily solution since the mysql service will be restarted. I attach the new mysqld_log.txt file in case that you find out something suspicious. It's really weird as i don't know if i have done something wrong with /etc/my.cnf file.
phpmyadmin tool as a root gives me this temporarily solution!

 

[Michaelit]

[SOLVED] from my side!
This variable sql_mode had been set in /usr/my.cnf file so by restarting mysql service, server was reading this file at first and /etc/my.cnf afterwards .