On Friday 21 March 2003 20:41, Salada Duncan wrote:

> 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.

You must have FILE privilege to use LOAD DATA INFILE. Do you have this 
privilege?


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to