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 t

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

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 with

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

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

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

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

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

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