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 vote279 views3 answers
Remove folders from remote git
SQL
0 vote284 views1 answer
How to add timestamp column in mysql
SQL
4 votes272 views1 answer
Oracle select first 10 rows
SQL
13 votes260 views4 answers
Mysql get last row
SQL
1 vote283 views2 answers
How to combine 2 tables in MySQL
SQL
21 votes267 views3 answers
Average sql
SQL
0 vote332 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL
-2 votes288 views1 answer
Trunc in sql
SQL
2 votes275 views2 answers
Mysql alter column default
SQL
0 vote269 views1 answer
Sql select min
SQL