MariaDB [test]> create role 'role-1';

Query OK, 0 rows affected (1.280 sec)

MariaDB [test]> grant select on mysql.user to 'role-1';

Query OK, 0 rows affected (0.211 sec)

MariaDB [test]> show grants for 'role-1';

+--------------------------------------------+

| Grants for role-1                          |

+--------------------------------------------+

| GRANT USAGE ON *.* TO 'role-1'             |

| GRANT SELECT ON `mysql`.`user` TO 'role-1' |

+--------------------------------------------+

2 rows in set (0.002 sec)

MariaDB [test]> create user u0@localhost;

Query OK, 0 rows affected (0.025 sec)

MariaDB [test]> show grants for u0@localhost;

+----------------------------------------+

| Grants for u0@localhost                |

+----------------------------------------+

| GRANT USAGE ON *.* TO 'u0'@'localhost' |

+----------------------------------------+

1 row in set (0.001 sec)

MariaDB [test]> GRANT 'role-1' TO 'u0'@'localhost';

Query OK, 0 rows affected (0.002 sec)

MariaDB [test]> show grants for u0@localhost;

+----------------------------------------+

| Grants for u0@localhost                |

+----------------------------------------+

| GRANT role-1 TO 'u0'@'localhost'       |

| GRANT USAGE ON *.* TO 'u0'@'localhost' |

+----------------------------------------+

2 rows in set (0.001 sec)

MariaDB [test]> GRANT role-1 TO 'u0'@'localhost';

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that

corresponds to your MariaDB server version for the right syntax to use near '-1

TO 'u0'@'localhost'' at line 1