Grants UGGH! Not working for some reason ...

2002-07-09 Thread Jay Blanchard
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

RE: Grants UGGH! Not working for some reason ...

2002-07-09 Thread Don Vu
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

FW: Grants UGGH! Not working for some reason ...

2002-07-09 Thread Jay Blanchard
[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

RE: Grants UGGH! Not working for some reason ...

2002-07-09 Thread Johnny Withers
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

Re: Grants UGGH! Not working for some reason ...

2002-07-09 Thread Gelu Gogancea
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

RE: Grants UGGH! Not working for some reason ...

2002-07-09 Thread Luc Foisy
[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

RE: Grants UGGH! Not working for some reason ...

2002-07-09 Thread Jay Blanchard
[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