[mythtv-users] infamous "Access denied" on mythtv-setup/frontend/backend
treythompson at gmail.com
Wed Feb 14 05:17:39 UTC 2007
> 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
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.
More information about the mythtv-users