Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql users and privileges list

SELECT * FROM mysql.user;

SELECT * FROM information_schema.user_privileges;
SELECT CONCAT('SHOW GRANTS FOR ''',user,'''@''',host,''';') FROM mysql.user;
SHOW GRANTS FOR 'my_user'@'localhost';
Source by alvinalexander.com #
 
PREVIOUS NEXT
Tagged: #mysql #users #privileges #list
ADD COMMENT
Topic
Name
4+6 =