[mythtv-users] Mysql permissions problem

Michael Tiller michael.tiller at gmail.com
Tue May 18 11:52:44 UTC 2010


On Mon, May 17, 2010 at 8:50 PM, Peter Abplanalp <
pta-myth at psaconsultants.com> wrote:

> On Mon, May 17, 2010 at 6:17 PM, Michael Tiller
> <michael.tiller at gmail.com> wrote:
> > On Mon, May 17, 2010 at 7:40 PM, Michael Tiller <
> michael.tiller at gmail.com>
> > wrote:
> > mysql> select user, host from user;
> > +------------------+-----------+
> > | user             | host      |
> > +------------------+-----------+
> > | mythtv           | %         |
> > | root             | 127.0.0.1 |
> > | debian-sys-maint | localhost |
> > | mythtv           | localhost |
> > | root             | localhost |
> > +------------------+-----------+
> > 5 rows in set (0.00 sec)
>
> that looks fine to me.
>
> i went back and looked at your original post and i noticed that you used:
>
>      mysql> grant all on mythconverg.* to mythtv@"%" identified by
> "mythtv";
>
> what i'm used to doing is putting both user and host in quotes or ticks a
> la:
>
>     mysql> grant all on mythconverg.* to "mythtv"@"%" identified by
> "mythtv";
>
> if you want to try this, i'd erase the current mythtv@% row from the
> user table first.
>

Erased previous entry added new one with quotes.  Didn't change anything.
:-(


> -peter
>
>
--
Mike
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20100518/7dc7d30c/attachment.htm>


More information about the mythtv-users mailing list