[mythtv] [mythtv-commits] Ticket #12112: Error in http://www.mythtv.org/wiki/MySQL_Time_Zone_Tables

[Tom Lichti]

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>