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 vote228 views1 answer
Power bi union columns
SQL
0 vote233 views1 answer
Create database like
SQL
1 vote219 views1 answer
Loading local data is disabled mysql
SQL
0 vote208 views1 answer
Low level operator in dbms
SQL
0 vote258 views1 answer
Sql constarint
SQL
2 votes230 views1 answer
Change primary key sql
SQL
1 vote228 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote211 views1 answer
Hive batch drop table
SQL
0 vote217 views1 answer
MySQL FIND_IN_SET()
SQL
1 vote240 views1 answer
Mysql show queries running
SQL