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 vote154 views1 answer
Query params sql insert python f string
SQL
13 votes207 views3 answers
Mysqldump structure only
SQL
0 vote150 views1 answer
Multiple tricky query in sql server
SQL
1 vote141 views1 answer
Select count distinct multiple columns sql server
SQL
0 vote151 views1 answer
Hibernate with springboot mysql
SQL
0 vote171 views1 answer
How to subquey to do not load in live database in
SQL
1 vote145 views1 answer
Python escape mysql
SQL
1 vote154 views3 answers
Default password of mysql
SQL
4 votes149 views2 answers
Xampp mysql database server is not starting mac m1
SQL
7 votes169 views2 answers
Sql remove duplicates based on column
SQL