Bug #2850 Changing a User's Privileges doesn't take effect immediately
Submitted: 17 Feb 2004 16:52 Modified: 19 Feb 2004 11:33
Reporter: Harrison Fisk Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:1.0.1a OS:Windows (Windows)
Assigned to: Michael G. Zinner CPU Architecture:Any

[17 Feb 2004 16:52] Harrison Fisk 
Description:
If you change a user's privileges in MySQL Administrator, then the user won't be affected immediately.

This also occurs if you add a new user, they won't be able to login immediately.

The problem is that it manipulates the underlying tables directly using INSERT/UPDATE/DELETE and doesn't do a FLUSH PRIVILEGES; afterwords.

How to repeat:
Add a new user.
Try to immediately login as them, it will fail.
Issue a flush privileges command.
Now you can login.

Suggested fix:
MySQL Administrator should FLUSH PRIVILEGES after changing user information.
[18 Feb 2004 10:42] Michael G. Zinner 
Thanks for submitting the report.

The issue has been fixed. The fix will be available in the next release 1.0.2a.