MariaDB [(none)]> SHOW GRANTS FOR 'maxscale'@'xxxxxxxxxx.com';
|
+---------------------------------------------------------------------------------------------------------------------------------+
|
| Grants for maxscale@xxxxxxxxxx.com |
|
+---------------------------------------------------------------------------------------------------------------------------------+
|
| GRANT maxscale_role TO 'maxscale'@'xxxxxxxxxx.com' |
|
| GRANT USAGE ON *.* TO 'maxscale'@'xxxxxxxxxx.com' IDENTIFIED BY PASSWORD '*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' |
|
+---------------------------------------------------------------------------------------------------------------------------------+
|
2 rows in set (0.00 sec)
|
MariaDB [(none)]> SHOW GRANTS FOR 'maxscale_role';
|
+---------------------------------------------------------------------------------------+
|
| Grants for maxscale_role |
|
+---------------------------------------------------------------------------------------+
|
| GRANT SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'maxscale_role' |
|
| GRANT SELECT ON `mysql`.`roles_mapping` TO 'maxscale_role' |
|
| GRANT SELECT ON `mysql`.`tables_priv` TO 'maxscale_role' |
|
| GRANT SELECT ON `mysql`.`user` TO 'maxscale_role' |
|
| GRANT SELECT ON `mysql`.`db` TO 'maxscale_role' |
|
+---------------------------------------------------------------------------------------+
|
5 rows in set (0.00 sec)
|
MariaDB [(none)]> SELECT user, host, default_role FROM mysql.user WHERE user = 'maxscale' AND host = 'xxxxxxxxxx.com';
|
+----------+---------------------------+---------------+
|
| user | host | default_role |
|
+----------+---------------------------+---------------+
|
| maxscale | xxxxxxxx.com | maxscale_role |
|
+----------+---------------------------+---------------+
|
1 row in set (0.00 sec)
|