MySQL - Show all granted privileges

Show all granted privileges for all users on your MySQL server.

SELECT user,host from mysql.user 


All privileges for users that are not local (@ 'localhost').

SELECT user,host from mysql.user WHERE host NOT IN ('localhost','127.0.0.1');