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 vote187 views1 answer
How to check replication lag in mySQL
SQL
0 vote194 views1 answer
Mysql persistence.xml
SQL
0 vote191 views3 answers
CONTACT FORM SQL
SQL
0 vote202 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
0 vote228 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote194 views1 answer
Sql select by content lenght
SQL
0 vote188 views2 answers
How to update the multiple rows in sql
SQL
0 vote201 views1 answer
Mysql min value row
SQL
1 vote227 views1 answer
Oracle show execution plan
SQL
0 vote194 views1 answer
Flask sqlalchemy remove duplicates
SQL