node1 {root} ((none)) > select @@version,@@version_comment;
|
+--------------------------------+-------------------------------------------------------+
|
| @@version | @@version_comment |
|
+--------------------------------+-------------------------------------------------------+
|
| 10.0.26-MariaDB-1~wheezy-wsrep | mariadb.org binary distribution, wsrep_25.13.raf7f02e |
|
+--------------------------------+-------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
node1 {root} ((none)) > CREATE ROLE foo;
|
Query OK, 0 rows affected (0.01 sec)
|
|
node1 {root} ((none)) > SELECT * FROM mysql.roles_mapping;
|
+-----------+------+------+--------------+
|
| Host | User | Role | Admin_option |
|
+-----------+------+------+--------------+
|
| localhost | root | foo | Y |
|
+-----------+------+------+--------------+
|
1 row in set (0.00 sec)
|
|
node1 {root} ((none)) > select * from information_schema.APPLICABLE_ROLES;
|
+----------------+-----------+--------------+
|
| GRANTEE | ROLE_NAME | IS_GRANTABLE |
|
+----------------+-----------+--------------+
|
| root@localhost | foo | YES |
|
+----------------+-----------+--------------+
|
1 row in set (0.00 sec)
|
|
-- second node in the same Galera cluster:
|
node2 {root} ((none)) > select @@version,@@version_comment;
|
+--------------------------------+-------------------------------------------------------+
|
| @@version | @@version_comment |
|
+--------------------------------+-------------------------------------------------------+
|
| 10.0.26-MariaDB-1~wheezy-wsrep | mariadb.org binary distribution, wsrep_25.13.raf7f02e |
|
+--------------------------------+-------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
node2 {root} ((none)) > SELECT * FROM mysql.roles_mapping;
|
+------+------+------+--------------+
|
| Host | User | Role | Admin_option |
|
+------+------+------+--------------+
|
| | | foo | Y |
|
+------+------+------+--------------+
|
1 row in set (0.00 sec)
|
|
node2 {root} ((none)) > select * from information_schema.APPLICABLE_ROLES;
|
Empty set (0.00 sec)
|