[mythtv-users] Database setup

[Michael Nguyen]

Harry Devine wrote:
> I can do all of those commands fine. I even followed the suggestion of
> another post where I did the "drop database mythconverg" command, then 
> ran thru the steps in that Wiki article you sent me.  All went well, 
> BUT, when I run mythtv-setup I'm getting the same "Host <ip> is not 
> allowed to connect to this MySQL server" error.
>
> How can I completely remove all of the mysql stuff and get back to a 
> clean slate?
>
> Thanks for the help,
> Harry
>   
Hi Harry,

The default configuration connects to "localhost" so you must not be 
connecting to localhost for your database.  Do the following:

mysql -uroot

GRANT ALL ON mythconverg.* TO mythtv@'%' IDENTIFIED BY "mythtv";
FLUSH PRIVILEGES;
GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@'%' IDENTIFIED 
BY "mythtv";
FLUSH PRIVILEGES;
\q

Try again.


Michael

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080322/364140a5/attachment.htm