MySQL - Show all granted privileges

Revision as of 21:26, 24 March 2020 by Ardaut (talk | changes) (Created page with "Show all granted privileges for all users on your MySQL server. <br> <pre>SELECT user,host from mysql.user </pre> <br> All privileges for users that are not local (@ 'localhos...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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');