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

1 vote131 views1 answer
Sql first
SQL
1 vote123 views1 answer
Sql auto date
SQL
0 vote139 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL
0 vote133 views1 answer
Function sum(text) does not exist postgres
SQL
1 vote135 views1 answer
Wordpress change http to https phpmyadmin
SQL
2 votes126 views1 answer
Oracle find constraints referencing a table
SQL
0 vote135 views1 answer
Systemverilog unique constraint unique values
SQL
9 votes137 views3 answers
Mysql run sql file
SQL
0 vote140 views1 answer
New rails app with mysql
SQL
0 vote143 views3 answers
Sql server import json
SQL