-----Original Message----- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 9:06 AM To: [EMAIL PROTECTED] Subject: re: load data infile question
Hi! 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? Yes, I have the FILE privilege. Duncan ----------------------------------------------- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
