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 vote210 views1 answer
Insert into Select * - NAYCode.com
SQL
1 vote200 views1 answer
Oracle grant on all tables in schema
SQL
13 votes208 views2 answers
Sql join 3 tables
SQL
2 votes191 views1 answer
Drop table if exists in postgres
SQL
0 vote190 views1 answer
SQL COMO ALTERA NOME DE TABELA
SQL
36 votes199 views6 answers
Delete from where sql
SQL
6 votes203 views2 answers
Postgresql database url
SQL
44 votes313 views4 answers
Mysql alter table add column first
SQL
0 vote204 views1 answer
Storing RGBA in mysql db
SQL
0 vote243 views1 answer
Like and not like together in sql
SQL