Sharing Databases and Tables between users in MySQL
[https://mariadb.com/kb/en/mariadb/roles/](MariaDB 10.0.5 has Roles); see if they provide what you desire.

(Yes, MariaDB is essentially compatible with MySQL; Roles is an extra feature.)