Roles and Permission Models in MySQL
Published September 15, 2026
By Sai Sree Ram Gundepudi
Create Role
CREATE ROLE read_only;Assign Role
GRANT SELECT ON *.* TO read_only;
GRANT read_only TO 'user1'@'localhost';