title: How to enable ONLY_FULL_GROUP_BY in MySQL
body: <p>I have disabled <code>ONLY_FULL_GROUP_BY</code> by using <code>SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));</code>. Now I want to restore the default settings.</p>
  
  <p>Is it possible to enable the <code>ONLY_FULL_GROUP_BY</code> in MySQL again?</p>
  
  <p>Thanks in advance</p>