title: how to change mysql sql mode after installation
body: <p>i have mysql installed and table created. i want to remove <code>strict_trans_tables</code> from sql mode, how to do that? I tried the fonllowing:
  1) go to phpmyadmin variable and edit sql mode, but mysql reset it back to default value</p>
  
  <p>2) followed <a href="https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-setting" rel="nofollow noreferrer">https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-setting</a>
  and tried in command line to reset sql mode:</p>
  
  <pre><code>sudo mysqld --sql mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  </code></pre>
  
  <p>3) located file <code>/etc/mysql/my.cnf</code> and tried to change setting there, but didn't find any sql mode info.</p>
  
  <p>Can i change sql mode after installation? how?</p>