Got it - thank you, I did not think about the meaning of file except as it
relates to MySQL. Re syntax - thanks.
On Sun, 31 Jul 2011, Claudio Nanni wrote:
Hi Doug,
1.FILE is GLOBAL because it refers to the ability of the user to read/write
files on the server host filesystem (where the filesy
Hi Doug,
1.FILE is GLOBAL because it refers to the ability of the user to read/write
files on the server host filesystem (where the filesystem permissions
allow).
2.
1) user@localhost OK, not recommended
2) 'user@localhost' WRONG
3) 'user'@'localhost' OK, BEST
single quotes prevent any
I have both a theory question and a question on implementation of privileges.
First theory. I have been using:
grant all privileges on db-name.* to user@localhost
identified by 'password';
Because I blunder about as root I never was impacted by 'file' being a global
permission. As 'lo
Mark,
Tuesday, October 01, 2002, 5:50:15 PM, you wrote:
MH> But root user is able to perform the write to file w/o issue.
MH> I wonder what the problem could be.
MH> I will upgrade to 3.23.52 but I don't think it will fix the problem.
MH> Is there anything else it could be?
As far as I remember
ue, 1 Oct 2002, Victoria Reznichenko wrote:
> Date: Tue, 1 Oct 2002 14:16:02 +0300
> From: Victoria Reznichenko <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: re: re: granting FILE privileges
>
> Mark,
> Monday, September 30, 200
Mark,
Monday, September 30, 2002, 5:48:59 PM, you wrote:
MH>
+-+
MH> | Grants for [EMAIL PROTECTED]
|
MH>
+
ate: Mon, 30 Sep 2002 13:53:01 +0300
> From: Victoria Reznichenko <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: re: granting FILE privileges
>
> Mark,
> Saturday, September 28, 2002, 12:16:31 AM, you wrote:
>
> MH> I keep trying to grant file privileges to
Mark,
Saturday, September 28, 2002, 12:16:31 AM, you wrote:
MH> I keep trying to grant file privileges to a user, but no matter what I do,
MH> it seems that the customer keeps getting access denied errors.
MH> They are trying to execute the following:
MH> select * into outfile '/tmp/list.txt' fi
I'm using FreeBSD 4.6 and MySQL 3.23.36
I keep trying to grant file privileges to a user, but no matter what I do,
it seems that the customer keeps getting access denied errors.
They are trying to execute the following:
select * into outfile '/tmp/list.txt' fields terminated by "|" lines termina
