Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
-
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.