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

7 votes253 views1 answer
Alter table add key sql
SQL
-1 vote291 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote276 views1 answer
Sqlalchemy.exc.OperationalError:
SQL
0 vote286 views1 answer
Sql select by content lenght
SQL
0 vote313 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
1 vote347 views1 answer
Best configuration for display table in sqlplus
SQL
1 vote288 views1 answer
Oracle create index if not exists
SQL
1 vote318 views1 answer
Oracle get current schema
SQL
1 vote295 views1 answer
How do you use sql in you company
SQL
6 votes297 views2 answers
Oracle
SQL