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 vote143 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote152 views1 answer
How to find all children of a record with only parent ID in sql
SQL
1 vote116 views2 answers
Get date from datetime postgresql
SQL
4 votes182 views3 answers
Mysql get column names from table
SQL
0 vote148 views1 answer
Run postgresql dump to csv
SQL
0 vote151 views1 answer
How to list function in psql
SQL
1 vote162 views1 answer
Show structure of table in sql
SQL
4 votes150 views1 answer
To date oracle with time
SQL
1 vote138 views1 answer
Importance of comment in mysql
SQL
2 votes145 views1 answer
SQL IF ELSE
SQL