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 vote259 views1 answer
How to delete duplicate rows in oracle
SQL
1 vote154 views1 answer
Sql server: query to find out all the places where the table is used
SQL
34 votes171 views6 answers
Install mysql client ubuntu
SQL
23 votes151 views1 answer
How remove column in mysql
SQL
0 vote157 views1 answer
On delete set default
SQL
0 vote131 views1 answer
Mysql workbench indent formatting
SQL
7 votes137 views1 answer
Append column sql
SQL
0 vote144 views1 answer
Mariadb mysql root access denied
SQL
3 votes157 views1 answer
Where id is in list sql
SQL
0 vote141 views1 answer
How to set sql_mode for a query in CI model
SQL