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