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

[R. G. Newbury]

On 08/04/14 03:57 PM, Tom Lichti wrote:
>
> On Tue, Apr 8, 2014 at 3:19 PM, R. G. Newbury <newbury at mandamus.org
> <mailto:newbury at mandamus.org>> wrote:
>
>     On 08/04/14 09:09 AM, Tom Lichti wrote:
>
>         On Tue, Apr 8, 2014 at 7:30 AM, <noreply at mythtv.org
>         <mailto:noreply at mythtv.org>
>
>
>
>         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.
>
>
>     I don;t why that last method should be deprecated. When doing it
>     that way, the password is not shown in clear text on the screen.
>
>     Not much of deal breaker for most of us, but something to remember
>     in many different scenarios.
>
>
> Sorry, maybe deprecated is the wrong word. I think the option name may
> have changed from '-p', I can't remember, and I don't have a mysql
> server handy right now to test it with. I vaguely recall using the '-p'
> option and it said something about it being vague, but still allowing me
> to use it. I'm sure someone who actually knows will post at some point...

No. It is still -p (or --password=).

Just type 'mysql  --help' and it will tell you all about it!
Geoff


-- 
              R. Geoffrey Newbury