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 vote321 views1 answer
Mysql2::Error: Incorrect string value: '\xE2\x80\x8B
SQL
1 vote373 views1 answer
Mysql login console
SQL
0 vote356 views1 answer
How to get nth number in sql
SQL
4 votes352 views4 answers
Rollback in sql
SQL
3 votes367 views1 answer
Sql print all names that start with a given letter
SQL
0 vote365 views1 answer
Neo4j command to run script file
SQL
1 vote387 views1 answer
Mariadb get column names from table
SQL
2 votes346 views2 answers
Sql percentage
SQL
2 votes332 views2 answers
Mysql show table column comments sql
SQL
0 vote316 views1 answer
Create domain sql
SQL