[mythtv-users] mythfilldatabase fails on every query

[Michael T. Dean]

On 04/30/2007 08:23 PM, Carl Reynolds wrote:
> Jeffrey Bush wrote:
> > My root user cannot
> > even make temporary tables, and the SELECT statement for him does show that
> > he has privileges to make them on all databases. I tried changing the db
> > engine but that didn't help. The error is:
> >
> > ERROR 1005 (HY000): Can't create table 'test' (errno: 13)
>
> When you tried creating the temporary table as root, did you specify a 
> database? I assume you did, but just thought I'd check.
>
> Try the following:
>     > SELECT * FROM mysql.db WHERE Db = "mythconverg";
>
> You are specifically interested in the Create_tmp_table_priv column. If 
> it is not "Y", you won't be able to create temporary table in the database.
And make sure the database files are in a directory to which the user 
running mysqld has write permission and that the user running mysqld has 
write permission to the database files...  That's what the error you're 
getting seems to indicate is the problem.

Mike