title: Change mysql timezone from phpMyAdmin
body: <p>I am trying to change the timezone of my database. I am on <strong>shared server</strong> and database support guys can not change it for me only. Time zone is currently <code>+1:00</code>  I want it as <code>+05:30</code>. I searched and tried following but nothing worked.</p>
  
  <pre><code>date_default_timezone_set('timezone_name');
  </code></pre>
  
  <p>Added to my <code>index.php</code> file.</p>
  
  <pre><code>mysql&gt; SET GLOBAL time_zone = 'timezone_name';
  </code></pre>
  
  <p>It says access restricted.</p>
  
  <pre><code>SET time_zone = timezone_name
  </code></pre>
  
  <p>Query run now row affected.</p>
  
  <p>My site is hosted on site-ground us server.</p>