Just an update... I was able to work around the problem by giving "insert" privileges to the user for the WHOLE database. This is definitely not optimal because I only wish this user to be able to insert into one table in the database. But as soon as I gave the user insert privileges for the whole database the "load data infile" command worked. This seems like a bug to me, perhaps it has been dealt with in newer versions though.
Duncan ----------------------------------------------- Duncan Salada Titan Systems Corporation 301-925-3222 x375 -----Original Message----- From: Salada, Duncan [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 11:08 AM To: 'Victoria Reznichenko'; [EMAIL PROTECTED] Subject: RE: load data infile question -----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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
