title: How to populate zone tables in mysql database within ubuntu with xampp
body: <p>I am trying to import time zones according to this document: <a href="http://dev.mysql.com/doc/refman/5.7/en/mysql-tzinfo-to-sql.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.7/en/mysql-tzinfo-to-sql.html</a>.</p>
  
  <p>When I try hitting even first command through terminal i.e. </p>
  
  <pre><code>mysql_tzinfo_to_sql tz_dir
  </code></pre>
  
  <p>it says</p>
  
  <pre><code>There were fatal errors during processing of zoneinfo directory 'tz_dir'
  </code></pre>
  
  <p>When I run:</p>
  
  <pre><code>mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
  </code></pre>
  
  <p>then it returns </p>
  
  <pre><code>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
  </code></pre>
  
  <p><strong>Operating System:</strong> Ubuntu</p>
  
  <p><strong>Server:</strong> XAMPP (having mariadb)</p>
  
  <p>So, I am not able to import timezone data into the zone tables of <code>mysql</code> database.</p>