Re: granting file privileges

2011-07-31 Thread doug
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

Re: granting file privileges

2011-07-31 Thread Claudio Nanni
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

re: re: re: granting FILE privileges

2002-10-01 Thread Victoria Reznichenko
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

re: re: granting FILE privileges

2002-10-01 Thread Mark Hennessy
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

re: re: granting FILE privileges

2002-10-01 Thread Victoria Reznichenko
Mark, Monday, September 30, 2002, 5:48:59 PM, you wrote: MH> +-+ MH> | Grants for [EMAIL PROTECTED] | MH> +

re: granting FILE privileges

2002-09-30 Thread Mark Hennessy
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

re: granting FILE privileges

2002-09-30 Thread Victoria Reznichenko
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