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

[Brad DerManouelian]

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

> i've tried every way i can think of to modify the "grant all" command
> including
> grant all on mythconverg.* to "%"@"%" identified by "%";
>
> Ideas?

I don't think you're using the grant command correctly. "identified  
by" part is talking about your password. So when you say identified  
by "frontend", you're assigning the password of frontend to root@%.  
You probably want to do this:

grant all on mythconverg.* to root@"frontend.domain.com" identified  
by "rootpassword";

Hope this helps..

-Brad