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 vote372 views1 answer
How to rename a database in tsql
SQL
0 vote274 views1 answer
Inner joint
SQL
1 vote271 views1 answer
Mysql show current queries
SQL
13 votes280 views2 answers
Mysql order by multiple columns
SQL
0 vote293 views4 answers
How to connect form to database
SQL
5 votes300 views1 answer
AND OR NOT operators sql
SQL
0 vote283 views1 answer
Como hacer un select entre fechas mysql
SQL
3 votes306 views3 answers
Stop mysql ubuntu
SQL
0 vote313 views1 answer
Doesn't have default value mysql
SQL
18 votes285 views3 answers
Mysql query add column with default string value
SQL