At 12:16 PM -0500 9/23/99, Martin Ramsch wrote:
>On Thu, 1999-09-23 19:42:43 +0300, Michael Widenius wrote:
>> >>>>> "Jacob" == Jacob Park <jpark@stripped> writes:
>> Jacob> [...] The problem is that periodically root loses it's
>> Jacob> permissions again and I have to reset them again
>> I haven't ever heard about a problem like the above.
>I don't understand what connection the root password has to the access
>problems of other users ...
>But, hasn't there been a bug with GRANT sometimes only changing the
>the password in memory but not writing the new password into
>mysql.user? Maybe Jacob's problem is related to this?
I'm not sure if it's just the password, but yes, I have found that it
doesn't hurt to issue a FLUSH PRIVILEGES after GRANT or REVOKE,
even though it's not supposed to be necessary. The conditions under
which this is necessary remain unclear to me.
Paul DuBois, paul@stripped