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 vote333 views1 answer
Mariadb select limit offset
SQL
1 vote315 views1 answer
Not exists mysql
SQL
2 votes373 views1 answer
Oracle run_duration to number
SQL
4 votes344 views2 answers
Tsql utf to local time
SQL
4 votes330 views1 answer
Change nls_date_format
SQL
1 vote386 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote351 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL
10 votes318 views4 answers
Primary key sql
SQL
13 votes390 views3 answers
Mysqldump structure only
SQL
0 vote341 views1 answer
Sql shell psql cannot enter password
SQL