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

[Trey Thompson]

> 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'
>
> 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...
>

Well, I know it's mysql permission related, but I can't for the life
of me figure out what the problem is.  If I change the mysql.txt file
for the mythtv user, and run setup, it connects to the db.

So, I've checked, and the user mythtv, on the host
mythtvbe.treythompson.local "appears" to have full permissions in the
mysql..user table.  And, looking at mysql..db, it also appears that
the same user has full privileges on mythconverg.  So, looking at
mythconverg, it also "appears" that the same user has full privileges.

Is there any way to UP the logging so that I can find out exactly
where the breakdown is occurring?

The other thing that's confusing, is that when trying to run
mythbackend as root (mysql), I get the Access denied error, but when I
run mythtv-setup and use the root login (mysql), it connects fine.

I'm about to pull whatever hair I have left... out.