The file resides in /var/tmp (I am using the full path): LOAD DATA INFILE '/var/tmp/whatever' INTO TABLE ...
-a On Thu, 20 Feb 2003, Ahmed S K Anis wrote: > If the File resides in the same machine as the Database, it should > work. > If the file resides where the your client program resides, then use > Load data local infile > > > > >>> Andy De Petter <[EMAIL PROTECTED]> Thursday, February 20, 2003 > 6:10:40 PM >>> > > Hello gurus, > > When I try to perform a LOAD DATA INTO, I get a "Permission Denied" > problem, although I (should) have the correct privileges, for a > specific > user: > > > GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `mydb`.* > TO > 'myuser'@'localhost' > > I am using MySQL 3.23.54. > > Has anyone had this problem before? or should I give more privileges > to > this user? The manual says that SELECT/INSERT should be sufficiant. > The > exact error I get is: > > Access denied for user 'myuser@localhost' (Using password: YES) > > Any feedback would be appreciated. > > -Andy > > -- Andy De Petter - http://www.techos.be/andy - [EMAIL PROTECTED] (ROT13) Expert IT Analyst - Belgacom ANS/EIS/ISA - http://www.belgacom.be --------------------------------------------------------------------- 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
