(source) To show one users privilges in mysql:

SHOW GRANTS FOR 'luser'@'localhost';

To list current users grants:

SHOW GRANTS;

Show all users:

select user,password,host from mysql.user;