Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MariaDB sql_mode

Discussion in 'Database Discussions' started by brpassos, Nov 20, 2016.

Tags:
  1. brpassos

    brpassos Registered

    Joined:
    Sep 8, 2016
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Brazil
    cPanel Access Level:
    Root Administrator
    I use MariaDB and when I configure sql_mode in the /etc/my.cnf file it does not work. Sql_mode always retains the same default value.
     
  2. tmcstom

    tmcstom Member

    Joined:
    Dec 31, 2014
    Messages:
    11
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Yes, in particular, check to see if the following file exists:

    /usr/my.cnf

    If so, you can remove it to ensure /etc/my.cnf is the only file utilized for MySQL configuration values.

    Thank you.
     
Loading...

Share This Page