phpmyadmin set defualt

Unnamed User

• September 25, 2024 04:43

Hi

I have set the sql_mode through PHPMyAdmin in the WHM menu to STRICT_TRANS_TABLES, NO_ENGINE_SUBSTITUTION, but after a while, I found that the system resets the default value of sql_mode back to 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. How can I set the default value so that the system does not revert to the original value?

• 

  cPRex Jurassic Moderator

  • September 25, 2024 14:31

  Hey there!  I don't believe that setting this through the PHPMyAdmin page will maintain the settings, as you are seeing.  You'll need to directly edit this through the /etc/my.cnf file on the server with your favorite text editor, and then restart the MySQL service so those changes are loaded.  Details on how you can do that can be found here:

  https://support.cpanel.net/hc/en-us/articles/360050089274-How-to-change-the-SQL-mode-in-MySQL-or-MariaDB

  0
• 

  Unnamed User

  • September 26, 2024 10:53

  Hi
  thank you

  0
• 

  cPRex Jurassic Moderator

  • September 26, 2024 13:27

  Sure thing!

  0

Please sign in to leave a comment.