MySQL
The unsupported SQL list for MySQL are as follows:
User & Role
| SQL |
| CREATE USER ‘finley’@‘localhost’ IDENTIFIED BY ‘password’ |
| ALTER USER ‘finley’@‘localhost’ IDENTIFIED BY ‘new_password’ |
| DROP USER ‘finley’@‘localhost’; |
| CREATE ROLE ‘app_read’ |
| DROP ROLE ‘app_read’ |
| SHOW CREATE USER finley |
| SET PASSWORD = ‘auth_string’ |
| SET ROLE DEFAULT; |
Authorization
| SQL |
| GRANT ALL ON db1.* TO ‘jeffrey’@‘localhost’ |
| GRANT SELECT ON world.* TO ‘role3’; |
| GRANT ‘role1’, ‘role2’ TO ‘user1’@‘localhost’ |
| REVOKE INSERT ON . FROM ‘jeffrey’@‘localhost’ |
| REVOKE ‘role1’, ‘role2’ FROM ‘user1’@‘localhost’ |
| REVOKE ALL PRIVILEGES, GRANT OPTION FROM user_or_role |
| SHOW GRANTS FOR ‘jeffrey’@‘localhost’ |
| SHOW GRANTS FOR CURRENT_USER |
| FLUSH PRIVILEGES |
