Stephen Liu wrote:
mysql> SHOW GRANTS FOR 'vmailuser'@'localhost';
+------------------------------------------------------------------------------------------------------------------+
| Grants for [EMAIL PROTECTED]
|
+------------------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'vmailuser'@'localhost' IDENTIFIED BY PASSWORD
'*A0F874BC7F54EE086FCE60A37CE7887D8B31086B' |
+------------------------------------------------------------------------------------------------------------------+
OK, the privileges are gone. USAGE is a synonym for "no privileges." If you want to
get rid of the user entirely, use DROP USER.
To safe guard, it would be better to run 'FLUSH PRIVELEGES'.
Can I re-run
REVOKE SELECT, INSERT, UPDATE, DELETE ON test.* FROM
'vmailuser'@'localhost';
then
FLUSH PRIVELEGES;
Yes. I think on this recent a version, it will have no effect, but will not
harm anything.
Cheers
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]