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