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 vote176 views1 answer
How to search query in python3 sqlite3
SQL
1 vote186 views1 answer
Sqlalchemy order_by
SQL
1 vote183 views2 answers
Mysql extract month
SQL
17 votes249 views4 answers
Mysql remove ubuntu
SQL
6 votes262 views1 answer
How to count number of rows in sql
SQL
1 vote201 views1 answer
Sql server kill all connections
SQL
1 vote196 views1 answer
Sql random sampling per group
SQL
0 vote191 views2 answers
How to use aggregate functions in sql
SQL
0 vote291 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote222 views1 answer
Replace \n sql
SQL