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

1 vote88 views1 answer
Avg mysql
SQL
0 vote103 views1 answer
Object Information
SQL
1 vote113 views1 answer
Postgresql delete cascade
SQL
0 vote104 views1 answer
Sql select column name like from multiple tables
SQL
1 vote111 views2 answers
Begin transaction sql
SQL
0 vote110 views1 answer
Sql find table by name
SQL
2 votes109 views5 answers
SQL trigger
SQL
13 votes105 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote101 views2 answers
How to check if a column exists in a SQL Server table?
SQL
1 vote104 views1 answer
Select 2 rows in sql
SQL