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 vote171 views1 answer
Copy row from db to db mysql
SQL
21 votes147 views4 answers
Oracle add column
SQL
0 vote135 views2 answers
Start mysql server using docker
SQL
0 vote130 views1 answer
Order by monthly in sql
SQL
0 vote136 views4 answers
Mysql select bottom 10 rows
SQL
2 votes154 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote149 views1 answer
Oracle calculate statistics on partition
SQL
0 vote142 views1 answer
How to put value in parameters in mysqldataadapter
SQL
0 vote153 views1 answer
Retornar apenas o ano mysql date
SQL
0 vote131 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL