[MXS-713] Grant information is not described adequately for binlog router Created: 2016-05-06  Updated: 2017-04-24  Resolved: 2017-04-24

Status: Closed
Project: MariaDB MaxScale
Component/s: binlogrouter
Affects Version/s: 1.4.3
Fix Version/s: 1.4.3

Type: Bug Priority: Minor
Reporter: Simon Mudd Assignee: Massimiliano Pinto (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2017-29, 2017-30, 2017-31, 2017-32

 Description   

The information about grants is not as clear as it could be here: https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale/setting-up-maxscale/

If the binlog router is being used then it's likely that the binlog router is on a different server to the backend "master". It's also possible that you have a cluster of binlog routers to provide HA functionality so there won't be a single server. It may be worth mentioning this and how this setup might work.

Also show "just the grants" as it's easier to read then each statement, so something like:

– Grants for auth user (to get grants)
CREATE USER 'auth_user'@'somewhere' IDENTIFIED BY 'xxxxxx';
GRANT SHOW DATABASES ON . TO 'auth_user'@'somewhere';
GRANT SELECT ON `mysql`.`db` TO 'auth_user'@'somewhere';
GRANT SELECT ON `mysql`.`tables_priv` TO 'auth_user'@'somewhere';
GRANT SELECT ON `mysql`.`user` TO 'auth_user'@'somewhere';

– Replication slave access (for maxscale to download binlogs)
CREATE USER 'slave_user'@'somewhere' IDENTIFIED BY 'xxxxx';
GRANT REPLICATION SLAVE ON . TO 'slave_user'@'somewhere';

This format is easier to put into a template for generating automatically.

Note: 'somewhere' is unlikely to be a single hostname or ip address but maybe using a wild-card entry like '192.168.5.%' as if you use specific hostnames/ips you'll need to add an entry for each host and that may be cumbersome.


Generated at Thu Feb 08 04:01:23 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.