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

5 votes380 views4 answers
Traduction
SQL
4 votes344 views3 answers
NOT NULL SQL
SQL
0 vote343 views1 answer
Select STR_TO_DATE(date_seance1,'DD-MM-YYYY')
SQL
1 vote362 views1 answer
Mysql add fields
SQL
0 vote335 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote343 views1 answer
Get number of rows in every table mysql
SQL
0 vote345 views1 answer
Mysql search multiple tables
SQL
22 votes418 views1 answer
Mysql workbench
SQL
0 vote345 views1 answer
Postgresql comandos basicos
SQL
0 vote389 views2 answers
Wordpress change url after migration mysql query
SQL