What's the error you're getting? What OS are you running on? If it's *nix, make sure the file you are trying to load, and the full path to that file, is readable by the user mysql runs as. I once had some files in a user's home directory I was trying to load and although the file was world-readable, the directory permissions restricted access.
--jeff ----- Original Message ----- From: "Salada, Duncan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, March 21, 2003 10:41 AM Subject: load data infile question > 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 > --------------------------------------------------------------------- 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
