I've just tried, and it seems to work .... This means, there is an error in the O'Reilly book (July 1999, 1st Edition) then. ;)
Thanks a lot, -Andy On Thu, 20 Feb 2003, Jerry wrote: > The search engine on www.mysql.com is always worth a look first ....... > > "For security reasons, when reading text files located on the server, the > files must either reside in the database directory or be readable by all. > Also, to use LOAD DATA INFILE on server files, you must have the FILE > privilege on the server host. " > > "you must have the FILE privilege on the server host. " > > http://www.mysql.com/doc/en/LOAD_DATA.html > > Did adding FILE to the permissions do it ? > > Jerry > > ----- Original Message ----- > From: "Andy De Petter" <[EMAIL PROTECTED]> > To: "Jerry" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, February 20, 2003 12:47 PM > Subject: Re: LOAD DATA INTO not working > > > > > > I can perfectly connect to the myqsl server, with this specific user .. he > > can select/insert/update/whatever, but he gets permission denied errors, > > when trying to do a load data infile ;-/ > > > > The user has: > > > > GRANT USAGE ON *.* TO 'myuser'@'localhost' IDENTIFIED BY > > PASSWORD 'password' > > GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `mydb`.* > > TO 'myuser'@'localhost' > > > > -a > > > > On Thu, 20 Feb 2003, Jerry wrote: > > > > > GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER ON `mydb`.* TO > > > 'myuser'@'localhost' IDENTIFIED BY > > 'password' > > > > mysql -u myuser -ppassword > > > > > > Does that do it ? > > > > > > Jerry > > > > > > ----- Original Message ----- > > > From: "Andy De Petter" <[EMAIL PROTECTED]> > > > To: <[EMAIL PROTECTED]> > > > Sent: Thursday, February 20, 2003 12:40 PM > > > Subject: LOAD DATA INTO not working > > > > > > > > > > > > > > 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) > > > > > > > > > > > > --------------------------------------------------------------------- > > > > 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 > > > > > > > > > > > > > > -- > > 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 > > > > -- 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