mysql environment variables
Hi all, I’m trying to set up some mysql miscellaneous, such as:
SET GLOBAL sql_mode = (SELECT REPLACE (@@ sql_mode, 'ONLY_FULL_GROUP_BY', ''));
max_connections = 1000
And a few more variables, my ubunto is 16.04 and I’m making the change in the mysql directory:
But the changes are not taking effect, the variables only change the value if I set them via the mysql console.
but when I perform the set via console after a restart of mysql the variables return to the default value and this is impacting on my application .. any light how to solve this problem of setar variable in mysqld.cnf ??
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.