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 > --------------------------------------------------------------------- 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
