I am using on a VPS service:
WHM 68.0.30
MySQL 5.6.38
php 7.1.15
I have root access in WHM.
I host several sites, all in a cagefs environment. Most use MySQL and currently all are set to strict mode (sql_mode='NO_ENGINE_SUBSTITUTION').
For 1 account, I would like to change this to:
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
I understand that where at all possible Strict Mode should be left as the MySQL default as to do otherwise has some risk of db corruption if the users code is not what it should be.
Is it possible to change strict mode for a single account? If it is, how can I accomplish this? I assure you I have tried but cannot get it to "take". I have edited my.cnf within cagefs/sitexxx/etc but no effect.
Any assistance greatly appreciated.
Regards
WHM 68.0.30
MySQL 5.6.38
php 7.1.15
I have root access in WHM.
I host several sites, all in a cagefs environment. Most use MySQL and currently all are set to strict mode (sql_mode='NO_ENGINE_SUBSTITUTION').
For 1 account, I would like to change this to:
sql_mode=IGNORE_SPACE,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
I understand that where at all possible Strict Mode should be left as the MySQL default as to do otherwise has some risk of db corruption if the users code is not what it should be.
Is it possible to change strict mode for a single account? If it is, how can I accomplish this? I assure you I have tried but cannot get it to "take". I have edited my.cnf within cagefs/sitexxx/etc but no effect.
Any assistance greatly appreciated.
Regards