MysQL: Show grants for users

Published by

Posted on May 09, 2009

mysql> show grants for ‘user’@’host’
or
select * from information_schema.user_privileges where grantee like “‘user’%”;

Tools
Maakit