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 vote292 views1 answer
Vbnet programatically convert type to db type
C#
6 votes352 views1 answer
Unity access child
C#Unity
0 vote293 views2 answers
Streamwriter c#
C#
0 vote313 views1 answer
Check if element in hashset c#
C#
0 vote232 views1 answer
Transform face player unity
C#
0 vote291 views1 answer
C# alphabetize a list of string
C#
0 vote337 views1 answer
Unity shader blend
C#Unity
0 vote293 views1 answer
Xml reader attributes
C#
0 vote269 views1 answer
C# radio button checked
C#
0 vote284 views1 answer
C# regex find last match
C#