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 vote114 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
13 votes107 views2 answers
Sqlite rename table
SQL
6 votes96 views1 answer
Rank function in oracle with example
SQL
6 votes102 views1 answer
SQL insert all columns
SQL
0 vote97 views1 answer
Sql character index
SQL
1 vote115 views1 answer
Trim leading zeros in sql
SQL
1 vote107 views1 answer
Mariadb alter user host
SQL
12 votes138 views6 answers
Distinct in sql server
SQL
-1 vote118 views1 answer
SQL query to convert DD/MM/YYYY to YYYY-MM-DD
SQL
0 vote91 views1 answer
Alter table add foreign key mariadb example
SQL