MySQL Forums
Forum List  »  Newbie

Impossible to definitely change sql_mode
Posted by: Samuel Gaïani-Porquet
Date: August 22, 2016 03:47AM

Hello there,

I'm trying to change mysql sql_mode from mysql='....' to simply mysql_mode='' as i'm setting up observium to recognize my network.

I'm quite a newbie so i followed mysql latest documentation which recommend to apply the following command in superuser mod:

SET GLOBAL sql-mode='';

While my computer is running it worked, but as soon as it reboot, the sql_mode get back to it default configuration.

Is there any way to modify sql_mode or am I may missing something?

I search the forum but I couldn't find someone who exactly encounter my problem...

Best regards,

Cypherx

Options: ReplyQuote


Subject
Written By
Posted
Impossible to definitely change sql_mode
August 22, 2016 03:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.