Hi Hal,
You might like to try setting the umask for the mysql user. I would
think the server would abide by the OS rules for permission settings.
You may be able to set the UMASK_DIR environment variable (as described
here http://dev.mysql.com/doc/refman/5.0/en/environment-variables.html).
Regard
At 10:17 11/01/2003 +0100, Dirkjan Ochtman wrote:
Hi,
server, I can DROP one of the tables, then I get the error again for the
other table, so then I restart the server again and I can DROP the last
table. The problem also persists on ALTERing TABLEs.
Please if possible for you send me a tes
Hi there,
I still have problems with this when using MySQL 4.0.8. When I try to DROP a
DATABASE, it will go through and delete all the tables, except the last two,
apparently because it "can't delete the table.myi file". When I restart the
server, I can DROP one of the tables, then I get the error
: Saturday, January 11, 2003 12:31 AM
Subject: Re: file permissions problem on ALTER TABLE
> Hmm, okay, but isn't the 3.23 supposed to be stable and thus more bugless
> than a gamma like 4.0.7?
>
> And also, I was wondering when 4 is going to be released as stable.
> Looking over
it, since it seems
like a real bug. :) But I guess it helps pretty good.
Regards,
Dirkjan
- Original Message -
From: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]>
To: "Dirkjan Ochtman" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Fri
Dirkjan,
> I am using MySQL 3.23.54 on Windows XP (with SP1). Today, I
encountered a
> weird problem: when trying to ALTER a TABLE, MySQL said that it no
> permissions to rename the *.myi file for that table.
Last 3.23 I used was 3.23.49, and I didn't have an ALTER TABLE problem,
neither on Win98
The manual says:
chown -R mysql.mysql /usr/local/mysql
You did not do that.
Do the same for MySQL's data directory.
Michael Sellers wrote:
>I'm very new to mysql. Just learning. I'm trying to correctly set up the
>permissions for the files under the mysql/ directory. I've included a
>lis
set your /home/Venu/ directory to be readable by all users:
chmod 755 /home/Venu
This has security issues but at least it'll fix your problem :)
Chris
-Original Message-
From: Venugopal Allavatam [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 1:40 PM
To: [EMAIL PROTECTED]
S
the mysql account under which the server runs does not have permission
to read
the file or its directory.
Venugopal Allavatam wrote:
> Hi All!
> i tried the load_file after changing the File_priv in the user table of
> mysql database for a particular user 'user1'...
>
> insert into ecg_datafi
