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 vote220 views1 answer
How to get alternate records from a table in sql
SQL
0 vote224 views1 answer
Generate random & unique mysql string
SQL
0 vote241 views3 answers
Osx stop mysql service
SQL
0 vote281 views1 answer
Sql select without column name
SQL
0 vote240 views1 answer
<sql:datasource var="Snapsho"
SQL
3 votes260 views1 answer
Oracle function return
SQL
4 votes248 views1 answer
Mysql copy table with new name
SQL
7 votes233 views2 answers
Mysql db size
SQL
7 votes233 views4 answers
Database dump mysql command
SQL
1 vote217 views1 answer
MySQL AND Operator
SQL