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 vote217 views1 answer
Ubuntu connect to mssql database
SQL
2 votes186 views2 answers
Exec procedure pl sql
SQL
0 vote199 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
2 votes207 views1 answer
Drop sequence
SQL
5 votes191 views2 answers
Oracle timestamp to date
SQL
10 votes196 views5 answers
Between keyword in sql
SQL
0 vote200 views1 answer
Insert into select with group by
SQL
0 vote182 views1 answer
Json_remove mysql
SQL
3 votes202 views1 answer
Oracle apex message quit website
SQL
0 vote182 views1 answer
RowDataPacket
SQL