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

2 votes130 views1 answer
C# create excel file
C#
2 votes92 views1 answer
Xml c#
C#
3 votes122 views1 answer
How to get the transform of an object in unity
C#
3 votes126 views1 answer
Mailkit send attachment
C#
0 vote118 views1 answer
C# get user appdata folder
C#
1 vote158 views1 answer
How to make an a i in unity
C#Unity
-2 votes123 views2 answers
C# .net core memory cache
C#
0 vote197 views1 answer
How to start a webpage from a button c#
C#
21 votes154 views3 answers
How to detect collision in unity
C#Unity
0 vote141 views1 answer
C# textbox tab column
C#