[mythtv-users] Problems with new setup???
watkinshome at gmail.com
Thu Oct 16 11:22:41 UTC 2008
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?
More information about the mythtv-users