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 vote135 views1 answer
How to make a destroy reference in unity
C#Unity
6 votes104 views2 answers
Unity copy to clipboard
C#
1 vote114 views1 answer
C# read array of objects from formdata
C#
0 vote97 views1 answer
C# square every digit of a number
C#
0 vote97 views1 answer
Open and close autocad api
C#
1 vote116 views1 answer
How to display doubles with trailing zeros in c#
C#
1 vote115 views1 answer
C# swtich
C#
2 votes128 views1 answer
Get enum int by name
C#
0 vote98 views1 answer
Get unix time in seconds C#
C#
0 vote105 views1 answer
Get gameobject layermask
C#