How to find all role in mysql

Copied CREATE USER 'dev1'@'localhost' IDENTIFIED BY 'dev1pass';
CREATE USER 'read_user1'@'localhost' IDENTIFIED BY 'read_user1pass';
CREATE USER 'read_user2'@'localhost' IDENTIFIED BY 'read_user2pass';
CREATE USER 'rw_user1'@'localhost' IDENTIFIED BY 'rw_user1pass';

Source: dev.mysql.com

How to find all role in mysql

Press CTRL+C to copy GRANT 'app_developer' TO 'dev1'@'localhost';
GRANT 'app_read' TO 'read_user1'@'localhost', 'read_user2'@'localhost';
GRANT 'app_read', 'app_write' TO 'rw_user1'@'localhost';

Source: dev.mysql.com

How to find all role in mysql

Press CTRL+C to copy GRANT ALL ON app_db.* TO 'app_developer';
GRANT SELECT ON app_db.* TO 'app_read';
GRANT INSERT, UPDATE, DELETE ON app_db.* TO 'app_write';

Source: dev.mysql.com

Similar codes

0 vote156 views1 answer
Alter domain sql
SQL
10 votes123 views6 answers
Between sql
SQL
9 votes124 views4 answers
Mysql show table fields
SQL
0 vote117 views1 answer
Sql clear table
SQL
1 vote206 views1 answer
Sql injection
SQL
0 vote141 views1 answer
Mysql remove bad character from all fields
SQL
0 vote121 views1 answer
Can we rollback deleted data in sql
SQL
0 vote124 views2 answers
Mysql updating multiple column values from array variable
SQL
0 vote124 views1 answer
Multiple left join mysql
SQL
8 votes136 views1 answer
Check mysql version phpmyadmin
SQL