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 vote260 views1 answer
Time in sql server
SQL
0 vote263 views1 answer
Postgresql array to rows
SQL
7 votes303 views4 answers
Index in mysql
SQL
0 vote265 views1 answer
Left join in codeigniter query builder
SQL
0 vote275 views1 answer
Addition of 2 column value in mysql
SQL
4 votes305 views1 answer
An error occurred while installing pg (1.2.3), and Bundler cannot continue. Make sure that `gem install pg -v '1.2.3' --source 'https://rubygems.org/'` succeeds before bundling.
SQL
0 vote268 views1 answer
Truncate a table then insert data
SQL
0 vote278 views1 answer
Varchar format not case sensitive sql
SQL
0 vote279 views1 answer
Como hacer una consulta en sql
SQL
1 vote331 views1 answer
How not to sort by average rating
SQL