Cascading REVOKE not working in MYSQL
Neither MySQL, nor Mariadb (https://mariadb.com/kb/en/library/revoke/), has implemented RESTRICT or CASCADE.

In general, a REVOKE can negate only an identical GRANT.  You cannot, for example, GRANT ALL ..., then REVOKE UPDATE ....

That is, the GRANT/REVOKE feature of MySQL and MariaDB is quite limited.

"Roles" are available in MySQL 8.0 and MariaDB 10.0.  (But I don't think that is relevant to your question.)


  Syntax naturally differs a little from dbms to dbms.


Change "a little" to "sometimes a lot".