[mythtv-users] Fixing minor errors in Myth database

[Paul Gardiner]

Fred Hamilton <fred at yonkitime.com> wrote:

>On Sun, Apr 28, 2013 at 6:16 AM, Paul Gardiner <lists at glidos.net>
>wrote:
>
>> GRANT ALL ON mythconverg.* TO mythtv@"%" IDENTIFIED BY mythtv;
>>
>
>I get a syntax error on that step:
>mysql> GRANT ALL ON mythconverg.* TO mythtv@"%" IDENTIFIED BY mythtv;
>ERROR 1064 (42000): You have an error in your SQL syntax; check the
>manual
>that corresponds to your MySQL server version for the right syntax to
>use
>near 'mythtv' at line 1
>
>If I leave off the "IDENTIFIED BY" bit:
>GRANT ALL ON mythconverg.* TO mythtv@"%";
>
>I don't get an error, but I imagine that bit's important...  But I know
>nothing about mysql so have no idea what I'm doing.
>
>Just tried
>  GRANT ALL ON mythconverg.* TO mythtv@"%" IDENTIFIED BY 'mythtv';
>(single quotes on 'mythtv' at the end) and it worked.  Is that correct?
>
>
>------------------------------------------------------------------------
>
>_______________________________________________
>mythtv-users mailing list
>mythtv-users at mythtv.org
>http://www.mythtv.org/mailman/listinfo/mythtv-users

Oops! Yes that's right.