*mysql> create user 'test'@'localhost' identified by 'pass';*
Query OK, 0 rows affected (0.00 sec)
*mysql> GRANT CREATE, DELETE ON *.* TO 'test'@'localhost';*
Query OK, 0 rows affected (0.00 sec)
*mysql> select * from information_schema.user_privileges where grantee like
"'test'@'localhost'";*
+-
How the F do you remove a user from the grant table?!!
The mysql.com site is down too by the way...
(r...@localhost) [(none)]> SHOW GRANTS FOR 'madc';
ERROR 1141 (42000): There is no such grant defined for user 'madc' on host
'%'
(r...@localhost) [(none)]> SHOW GRANTS FOR 'madc'@;
ERROR 1141 (42
