Hi, ----- Original Message ----- From: "Jay Blanchard" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, July 09, 2002 7:01 PM 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 ...this can be a problem.I think it should be work if you add and "-h 'theservername' > 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