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

5 votes316 views2 answers
C# remove first three characters from string
C#
0 vote306 views1 answer
Startup c# class winform
C#
2 votes337 views1 answer
Hide console window c#
C#
0 vote320 views1 answer
Unity 2D how to make top-down look controller
C#Unity
0 vote295 views1 answer
Set data annotation text in model c#
C#
0 vote287 views1 answer
Parse json C#
C#
0 vote344 views1 answer
Get selected item datagrid wpf
C#
11 votes320 views3 answers
Enum get all values C#
C#
11 votes316 views2 answers
C# random choice
C#
2 votes286 views1 answer
Get position of gameobject unity
C#