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 vote165 views1 answer
Sql auto timestamp
SQL
0 vote188 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote211 views1 answer
Psql create usr
SQL
32 votes183 views6 answers
Insert into values select
SQL
3 votes187 views2 answers
Postgresql remove not null constraint
SQL
0 vote207 views1 answer
Mssql last day of month
SQL
34 votes178 views6 answers
Install mysql client ubuntu
SQL
24 votes180 views4 answers
Postgres remove database
SQL
0 vote173 views1 answer
Sql contains numeric characters
SQL
20 votes177 views4 answers
Sqlite create table if not exists
SQL