RE: Grants UGGH! Not working for some reason ...
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
RE: Grants UGGH! Not working for some reason ...
The user might need the FILE permission, I'm not sure. Also might need the LOCK TABLES permission. http://www.mysql.com/doc/G/R/GRANT.html - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Jay Blanchard [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 09, 2002 11:23 AM To: [EMAIL PROTECTED] Subject: FW: Grants UGGH! Not working for some reason ... [snip] 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. [/snip] That's what I meant. I have reloaded MySQL, flushed, stopped and started the server. The killer is that this user is able to access the database just hunky-dorie, do selects, inserts, deletes, updates. Thanks! 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
Re: Grants UGGH! Not working for some reason ...
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
RE: Grants UGGH! Not working for some reason ...
[snip] 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. [/snip] That's what I meant. I have reloaded MySQL, flushed, stopped and started the server. The killer is that this user is able to access the database just hunky-dorie, do selects, inserts, deletes, updates. Thanks! Jay sql, mysql, query If you use the GRANT command, you don't have to flush privileges. If you UPDATE,INSERT your own grant records, then you have to flush. Try granting FILE privilege. mysqlimport is LOAD DATA INFILE like, which needs the FILE privilege - 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
RE: Grants UGGH! Not working for some reason ...
[snip] 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, ... [/snip] Figured it out. The user must have FILE privileges in order to execute items like mysqlimport from the command line or a script that generates command line like commands. Thanks! 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