MysQL: Show grants for users

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

Tools
Maakit

May 9, 2009 Post Under MySQL - Read More

Comments are closed.