[mythtv-users] infamous "Access denied" on mythtv-setup/frontend/backend

[Trey Thompson]

> Trey Thompson wrote:
> > well, aparantly I did something to really foul things up.
> > $ mysql -u mythtv -p -e "show database"
> > returns the list of databases
> > $ mysql -u root -p -e "show database"
> > does also
> >
> > But, mythtv-setup  gives "Access denied for user 'mythtv'@'%' to
> > database 'mythconverg'
>
> Maybe you need to make sure that mythtv user and the host that is
> accessing the dB have access.
>
> mysql>grant all PRIVILEGES on mythconverg.* to mythtv@'<yourhostname>'
> identified by '<pwForMythtvUser';
>
>
> >
> > I haven't made any sql changes.
> > mysql.txt is the same as it was in October
> >
> > backend won't start either, giving the same error.
> >
> > How do I figure out what the heck I did?
> >
> > I've read about 30 posts to the list for "access denied for user", and
> > they all point to mysql.txt problems, or Wilson's mysql setup...
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
> >
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

I'll be honest here, it's working, and I REALLY am not sure why.  I
think it's related to the mysql.txt file having "localhost" in it
instead of the IP.  But, I haven't changed that file, so I must have
changed it in mythtv-setup or something.