That's going to be a bit out of date !! I'd suggest a combination of Paul DuBois's latest offering in blue and the www.mysql.com search engine.
Keeps me out of trouble, well mostly ! Jerry ----- Original Message ----- From: "Andy De Petter" <[EMAIL PROTECTED]> To: "Jerry" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 1:00 PM Subject: Re: LOAD DATA INTO not working > > 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
