[mythtv-users] mythfilldatabase fails on every query

[Carl Reynolds]

Jeffrey Bush wrote:
> Hi,
> 
> I just installed MythTV and I have just finished importing mc.sql into my
> mysql database and running mythtv-setup. Like I should, I than ran
> mythfilldatabase, which ends up failing no every query. It cannot create the
> tables and it cannot insert (obviously) because the tables don't exist (and
> that is the error it gives).
> 
> 


Try running the following queries:
   $ mysql -p -u root:
    > GRANT ALL ON mythconverg.* TO mythtv at localhost IDENTIFIED BY "mythtv";
    > GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv at localhost;
    > FLUSH PRIVILEGES;

If you already have the password for mythtv set, you don't need the 
IDENTIFIED BY clause.

It looks as if mythtv has not been granted CREATE TEMPORARY permissions.

You could also try
    SELECT * FROM mysql.user WHERE user = "mythtv";

to see what permissions mythtv actually has.



Carl.