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
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
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,
[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
[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