title: How to fix `unknown variable 'sql-mode=ANSI'`?
body: <p>Using MySQL 5.5.27, in my.cnf I have:</p>
  
  <pre><code>[mysql]
  sql_mode=ANSI
  </code></pre>
  
  <p>Upon starting the mysql console I get:</p>
  
  <pre><code>unknown variable 'sql-mode=TRADITIONAL'
  </code></pre>
  
  <p>The MySQL doc <a href="http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html" rel="noreferrer">Server SQL Modes</a> shows that option, so why does it not work?</p>
  
  <p>(If it helps, I am on OSX Lion)</p>
  
  <p>Also, <a href="http://pastebin.com/Qz7TYGsC" rel="noreferrer">here is a pastebin showing the things another person has tried, with no solution</a>.</p>