Difference between revisions of "MySQL - Show all granted privileges"

(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...")
 
(No difference)

Latest revision as of 21:26, 24 March 2020

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