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 vote255 views1 answer
T-sql check if data exists
SQL
0 vote259 views1 answer
User, group, or role 'open' already exists in the current database.
SQL
0 vote234 views8 answers
Convert sql query to linq online
SQL
1 vote266 views7 answers
Filter
SQL
0 vote263 views4 answers
Mysql on kubernetes
SQL
0 vote214 views1 answer
Get last run query sql server
SQL
1 vote257 views2 answers
How to add amount between date in sql
SQL
17 votes253 views3 answers
How to change a collumn name in sql
SQL
0 vote260 views1 answer
Postgresql certain first 4 characters in string
SQL
1 vote284 views1 answer
Psql view enum values
SQL