Hi everyone,

I am using MySQL 3.23.49 and have started having a problem with the "load
data infile" command.

I recently created a new user with select,insert,update,and delete on one
table only (tableA).  Because I want the user to be able to use "load data
infile" to load records into tableA, I also gave it the file privilege on a
global scale (which is the only way to do it AFAIK).  Yet when I attempt to
use "load data infile FILE into tableA" after having connected using the
mysql client, I get an access denied message.  Is there something else I
need to do?

Some other pertinent info...
- Yes, I have flushed privileges after giving privileges
- I know "load data infile" works (in general) because I have another user
that could do it without any trouble.

Duncan

-----------------------------------------------
Duncan Salada
Titan Systems Corporation
301-925-3222 x375

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to