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 vote232 views1 answer
Name of today sql
SQL
0 vote222 views1 answer
Windows aggregate functions in postgresql
SQL
0 vote210 views1 answer
Systems sql
SQL
2 votes247 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote212 views1 answer
Mysql Error Code: 1005
SQL
0 vote219 views4 answers
Mysql count table rows
SQL
5 votes223 views1 answer
Find table from column name in sql
SQL
2 votes176 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote287 views1 answer
Python get backup of sql
SQL
0 vote179 views1 answer
Mysqli or pdo
SQL