[KLUG Members] mysql

Adam Tauno Williams awilliam at whitemice.org
Tue Sep 7 04:51:14 EDT 2004


> After changing user permission user need to logout so that permission can
> work. Is this common?

Did you do a "FLUSH PRIVILEGES;" after your statements?  This is
required if you modified the permissions tables directly (bad idea, most
databases growl at you when you try such things),  but shouldn't be
required if you used GRANT / REVOKE.

http://dev.mysql.com/doc/mysql/en/Adding_users.html



More information about the Members mailing list