[mythtv-users] MySQL mythconverg permissions.... i give up.

[Brad DerManouelian]

On Mar 18, 2006, at 3:00 PM, Ed Gradek wrote:

> Hi All,
>
> I've spent the last few days trying to figure this out on my own,  
> searching
> the net, asking friends, and I'm all out of options.
>
> Access denied for user 'root'@'frontend.domain.com' (using  
> password: YES)

You're trying to connect to mysql as root at frontend.domain.com instead  
of mythtv at backend.domain.com. You need to change this in the frontend  
setup.

>
> I've tried all combinations of the permissions section from the
> myth-howto....:
> $ mysql -u root mythconverg
> mysql> grant all on mythconverg.* to mythtv@"%" identified by  
> "mythtv";
> mysql> flush privileges;

As an aside.. according to your mysql command here, you have no  
password for mysql's root account. You should probably protect your  
db with a password... just in case.