[mythtv] [mythtv-commits] Ticket #12112: Error in http://www.mythtv.org/wiki/MySQL_Time_Zone_Tables
Tom Lichti
tom at redpepperracing.com
Tue Apr 8 13:09:28 UTC 2014
On Tue, Apr 8, 2014 at 7:30 AM, <noreply at mythtv.org> wrote:
> #12112: Error in http://www.mythtv.org/wiki/MySQL_Time_Zone_Tables
> --------------------------------------+------------------------
> Reporter: pinnerite at ... | Owner:
> Type: Bug Report - General | Status: new
> Priority: minor | Milestone: unknown
> Component: MythTV - General | Version: 0.27-fixes
> Severity: high | Keywords: Timezone
> Ticket locked: 0 |
> --------------------------------------+------------------------
> The site offers the line:
>
> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p<yourpassword>
> mysql
>
> That did not work. This one did though:
>
> mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql --user=root --password=xxx
> mysql
>
> Just an edit needed to the web page.
>
While what you show will work, so would:
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root
-p"<yourpassword>" mysql
or
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql
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.
Tom
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-dev/attachments/20140408/d26be2df/attachment.html>
More information about the mythtv-dev
mailing list