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

81 votes218 views6 answers
Benoit Mandelbrot
C#
5 votes158 views1 answer
C# send email
C#
1 vote145 views1 answer
C# override index operator
C#
-1 vote204 views1 answer
Unity check if colliders are touching
C#
1 vote169 views1 answer
C# get pressed key
C#
0 vote163 views1 answer
Nunjucks conditional
C#
0 vote146 views1 answer
C# How to display text in console
C#
2 votes156 views1 answer
Asp.net core 3.1 routing
C#
0 vote153 views1 answer
Jagged array to 2d array c#
C#
0 vote146 views1 answer
Asp.net get query string parameter
C#