[MXS-3050] Setting Up MaxScale documentation should include instructions on how to configure the MaxScale grants in ClustrixDB Created: 2020-06-23  Updated: 2021-08-26  Due: 2020-07-06  Resolved: 2021-08-26

Status: Closed
Project: MariaDB MaxScale
Component/s: Documentation
Affects Version/s: None
Fix Version/s: 2.5.16

Type: Bug Priority: Minor
Reporter: Henry Hwang (Inactive) Assignee: markus makela
Resolution: Fixed Votes: 0
Labels: None


 Description   

The Setting Up MaxScale documentation https://mariadb.com/kb/en/mariadb-maxscale-24-setting-up-mariadb-maxscale/ should include instructions on how to create the maxscale account in ClustrixDB.

CREATE USER 'maxscale'@'%' IDENTIFIED BY 'maxscale_pw';
GRANT SELECT ON SYSTEM.* TO 'maxscale'@'%';
GRANT SHOW DATABASES ON . TO 'maxscale'@'%';

Note that the GRANT SELECT may be overly permissive and you may need to check with the MaxScale team for which SYSTEM tables the maxscale account should have SELECT privs on.



 Comments   
Comment by Jacob Moorman (Inactive) [ 2020-07-22 ]

KennethDyer Assess for bearing on Xpand.

Comment by markus makela [ 2021-08-25 ]

The Xpand tutorial didn't include the required grants.

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