mysql - usefull stuff with users

gistfile1.sql

-- http://dba.stackexchange.com/questions/13083/cant-remove-grant-usage
-- in host, use '%' as wildcard
grant usage on *.* to 'user'@'host' identified by 'password';
grant all privileges on database.* to 'user'@'host';

show grants;
show grants for user;
show grants for user@host;

grant super on *.* to 'user'@'host' identified by 'password';

drop user 'user'@'host';