[mythtv-users] Problems with new setup???

[David Watkins]

On 16/10/2008, Per Jørgensen <myth at pbj-design.dk> wrote:
> David Watkins wrote:
> > On 16/10/2008, Per Jørgensen <myth at pbj-design.dk> wrote:
> >
> >> David Watkins wrote:
> >>
> >>>> Afterwards I'm testing the DB - with this command:
> >>>> # mysql -p -u mythtv
> >>>> Enter password:
> >>>> ERROR 1045 (28000): Access denied for user 'mythtv'@'localhost' (using
> >>>> password: YES)
> >>>>
> >>>>
> >>>>
> >>> You need to get this working.
> >>>
> >>> It looks like a permissions (PRIVILEGE) issue to me but I can't really
> >>> read you database tables in my mail reader.
> >>>
> >>>
> >> I've tried - using this link as source
> >> http://www.mythtv.org/docs/mythtv-HOWTO-6.html
> >>
> >
> > I presume you mean you used this command to set the privileges?
> >
> > mysql> grant all on mythconverg.* to mythtv@"%" identified by "mythtv";
> > mysql> flush privileges;
> >
> > have you tried replacing % with localhost?
> >
> > I'm not the best person to help you with this because I got into a
> > mess when I changed my network settings and took ages to get the
> > permissions working again without really understanding what I was
> > doing.  I kept finding examples of the above command using different
> > arrangement of the quotation marks.  It also took be a long time to
> > realise that 'identified by' means 'using password'.  At least I think
> > it does.
> >
>
> Actually I was using this line:
>
> Finally, if you just want to restrict by IP subnet (in this example, the
> 192.168.1. network):
>
>    ||
>
>    $ mysql -u root mythconverg
>    mysql> grant all on mythconverg.* to mythtv@"172.16.20.%" identified by "mythtv";
>    mysql> flush privileges;
>
>    Which is my actual networksettings.
>    Since I'm running with 3 frontends - I'm needing to contact from the subnet!
>    But identified is the actual passwd you'll need to use. Thats also why I'm confused and don't understand why this ain't working

Can you connect to mysql from a remote machine?

Can you connect to mysql locally as a different user?

Is your hosts file or DNS setup correct?

It was changing my subnet that got me into the same situation that you
seem to be in.  I started to come to the conclusion that the format of
the Grant commnad has changed since that wiki page was written, but I
don't know.  I did get it working in the end :-) somehow.

Maybe someone who understands this stuff can chime in?