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

25 votes230 views6 answers
Change column name mysql
SQL
2 votes131 views1 answer
Sql create database
SQL
12 votes121 views5 answers
Sql merge
SQL
0 vote134 views1 answer
Create synonym for dblink in oracle
SQL
0 vote131 views1 answer
Mariadb maximum left join
SQL
2 votes139 views1 answer
Datetrunc
SQL
0 vote128 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
-1 vote173 views2 answers
Sql search all tables for attributes
SQL
14 votes142 views5 answers
Set password for postgres user ubuntu
SQL
1 vote462 views1 answer
Mysql event last execution
SQL