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 vote240 views2 answers
C# traverseall elements in class property
C#
1 vote234 views1 answer
In Asp.Net Core core how to I get the web site's IP address?
C#
8 votes249 views1 answer
Lockstate untiy
C#
38 votes230 views2 answers
How to do a foreach loop in c# for dictionary
C#
0 vote247 views1 answer
How to pass object as test case in nunit c#
C#
4 votes264 views1 answer
Use a for loop to sum an array c#
C#
0 vote229 views1 answer
Unity script template folder
C#
5 votes252 views2 answers
C# read file into a string
C#
3 votes245 views4 answers
Convert string to array c#
C#
3 votes230 views1 answer
Move file from one folder to another c#
C#