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

10 votes338 views1 answer
Set width of rect transform unity
C#
7 votes344 views2 answers
How to make a character move in unity 3d
C#
0 vote299 views1 answer
Yes no confirmation modal javascript
C#
0 vote445 views1 answer
Iterate though data in firebase unity
C#Unity
14 votes348 views5 answers
React add class conditionally
C#
0 vote380 views2 answers
Unity screentoworldpoint
C#
0 vote355 views1 answer
C# e-mail send
C#
0 vote333 views1 answer
How to redirect to extern page in .net core
C#
1 vote367 views1 answer
How to make an a i in unity
C#Unity
2 votes322 views1 answer
How to change the title of the console in c#
C#