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

8 votes363 views3 answers
Postgres database sizes
SQL
15 votes324 views2 answers
Select Options
SQL
1 vote313 views1 answer
Mysql random limit 1
SQL
2 votes320 views2 answers
Mysql show table column comments sql
SQL
0 vote369 views1 answer
Postgres rename database
SQL
2 votes310 views1 answer
Sqlite indexes
SQL
2 votes342 views3 answers
Row number mssql
SQL
0 vote325 views2 answers
Sql join on wildcard
SQL
12 votes355 views6 answers
How to install sqlite3 in python
SQL
0 vote342 views1 answer
Mod in sql
SQL