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
