[mythtv-users] MySQL mythconverg permissions.... i give up.
myth at dermanouelian.com
Sat Mar 18 20:13:12 UTC 2006
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,
> 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
> I've tried all combinations of the permissions section from the
> $ mysql -u root mythconverg
> mysql> grant all on mythconverg.* to mythtv@"%" identified by
> 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.
More information about the mythtv-users