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]