Skip to main content

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: 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 | +-------------------------------------------------------------------------------------------------------------------------------------------+
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,

Comments

5 comments

Date Votes
  • 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!
    0
  • 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: Thank you.
    0
  • 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!
    0
  • 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!
    0
  • 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 .
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post