<div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Tue, Apr 8, 2014 at 7:30 AM, <span dir="ltr"><<a href="mailto:noreply@mythtv.org" target="_blank">noreply@mythtv.org</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
#12112: Error in <a href="http://www.mythtv.org/wiki/MySQL_Time_Zone_Tables" target="_blank">http://www.mythtv.org/wiki/MySQL_Time_Zone_Tables</a><br>
--------------------------------------+------------------------<br>
Reporter: pinnerite@… | Owner:<br>
Type: Bug Report - General | Status: new<br>
Priority: minor | Milestone: unknown<br>
Component: MythTV - General | Version: 0.27-fixes<br>
Severity: high | Keywords: Timezone<br>
Ticket locked: 0 |<br>
--------------------------------------+------------------------<br>
The site offers the line:<br>
<br>
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p<yourpassword><br>
mysql<br>
<br>
That did not work. This one did though:<br>
<br>
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql --user=root --password=xxx<br>
mysql<br>
<br>
Just an edit needed to the web page.<br></blockquote><div><br></div><div>While what you show will work, so would:</div><div> </div><div>mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p"<yourpassword>" mysql<br>
</div><div><br></div><div>or</div><div><br></div><div>mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql<br></div><div><br></div><div>which would prompt for the password (although I think that method is being deprecated?). Like Perl, there is more than one way to do it.</div>
<div><br></div><div>Tom</div></div></div></div>