if you don't restart MySQL after changing the grants priviliges, you have to issue the "flush privileges" command from the MySQL Monitor. If you don't do either one your privilege changes will not take affect.
not sure if when you said "reloaded" you meant "flush privileges" but if not try it and see how it goes. hope that helps, Don -----Original Message----- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 12:02 PM To: [EMAIL PROTECTED] Subject: Grants UGGH! Not working for some reason ... Hi all! I have a user that I am specifying for one database within the system. I have granted, reloaded, deleted, re-done, and screamed at the server. None the less, it still will not allow this user to do mysqlimport, as follows; mysqlimport --user=rcr_user --password=thepassword -f --fields-terminated-by ="," rcr tblCDR.tmp mysqlimport: Error: Access denied for user: 'rcr_user@localhost' (Using password: YES), when using table: tblCDR I have 3 rcr_users now, one at 'localhost' one at '127.0.0.1' and one at 'theservername'. All have been granted select, insert, update, delete on the database in question. I also have this user in a PHP script that is able to do an INSERT INTO from the script that works fine. So, have I lost it completely? (I knew that this day would come :^) ) Any hints? I have read everything at http://www.mysql.com, I have looked all through my trusty MySQL book, I have made offerings to the gawds of database(s). Thanks in advance... Jay sql, mysql, query --------------------------------------------------------------------- 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