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

-2 votes340 views2 answers
Add auto_increment column to existing table mysql
SQL
0 vote364 views1 answer
Mysql insert multiple rows based on select
SQL
4 votes321 views2 answers
Oracle default date format
SQL
3 votes321 views2 answers
How to list columns for particular tables in postgresql
SQL
1 vote299 views2 answers
Oracle replace
SQL
60 votes527 views6 answers
Add column in sql
SQL
0 vote355 views1 answer
Add user mysql wordpress
SQL
0 vote328 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote277 views0 answer
SQL
0 vote315 views2 answers
How to check if sqlite table exists in nodejs
SQL