[mythtv-users] Fixing minor errors in Myth database

[Fred Hamilton]

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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130428/cf50a1d8/attachment.html>