[mythtv-users] mysql goof

[Brad DerManouelian]

On Mar 11, 2006, at 6:25 PM, jason wrote:

>
> I'm just getting my mythtv system set up and I did something goofy  
> in the
> config so when I try to run mythbackend, mythfrontend, mythsetup, etc
> mysql complains that:
>
> host 'mythbox' is not allowed to connect to this MySQL server
>
> How do I fix that?  Responses of RTFM welcome if you point the way  
> the the
> FM.

Sounds like you just need to grant privileges to your myth user and  
host name.
mysql> GRANT ALL PRIVILEGES ON * TO user at hostname IDENTIFIED BY  
'password' WITH GRANT OPTION;

Typed from memory, but I think that's right.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20060311/82347564/attachment.htm