[mythtv-users] mythfilldatabase fails on every query
bushj at rpi.edu
Tue May 1 02:05:35 UTC 2007
Thanks for your help. I got it fixed. I did chmod 777 on /var and /tmp and
now CREATE TEMPORARY TABLE works perfectly fine and mythfilldatabase is
One last question. Is it a security issue to have /var and /tmp be rwx by
all? This computer is solely a PVR, but is (obviously) on the internet.
Is there any risk?
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Michael T. Dean
Sent: Monday, April 30, 2007 9:49 PM
To: Discussion about mythtv
Subject: Re: [mythtv-users] mythfilldatabase fails on every query
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
> > 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
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.
mythtv-users mailing list
mythtv-users at mythtv.org
More information about the mythtv-users