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 vote275 views2 answers
Create-toys-table-with-toy_name-column
SQL
1 vote271 views3 answers
Drop unique key constraint in sql server
SQL
1 vote256 views1 answer
Mysql connect command
SQL
0 vote268 views1 answer
Qt qsql check if table exist
SQL
2 votes260 views1 answer
Oracle find unusable indexes
SQL
2 votes249 views1 answer
Oracle sql query to make column data uppercase
SQL
0 vote271 views1 answer
How to move a column to different spot mysql
SQL
0 vote478 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote265 views1 answer
Mariadb hours between two dates
SQL
0 vote231 views0 answer
SQL