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 vote168 views1 answer
Price-colour
SQL
9 votes160 views2 answers
Cmd to rename a collumn name in sql
SQL
0 vote162 views1 answer
Update top 100 sql
SQL
4 votes181 views2 answers
Bulk kill mysql processlist
SQL
0 vote163 views1 answer
Do postgresql
SQL
0 vote197 views1 answer
Search In the Data using ObjectName
SQL
1 vote184 views3 answers
Mysql on delete set null
SQL
0 vote176 views1 answer
Amount of entries in a table psql
SQL
0 vote174 views1 answer
Providername system.data. mysql
SQL
-1 vote174 views1 answer
What is in operator
SQL