title: How do I update the timezone to Eastern time in mysql properly?
body: <p>I am trying to set the timezone on my mysql server
  In my my.cnf file I have:</p>
  
  <pre><code>default-time-zone = '-05:00'
  </code></pre>
  
  <p>When I run <code>SELECT NOW( )</code> in mysql I get <code>2015-02-05 04:13:57</code>
  Note: It should have returned '2015-02-05 10:13:15'</p>
  
  <p>I want to set it so it has the Eastern time zone.</p>
  
  <p>I ran the query: <code>SELECT @ @global.time_zone , @ @session.time_zone</code></p>
  
  <pre><code>@@global.time_zone  @@session.time_zone
  SYSTEM              SYSTEM
  </code></pre>