Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
6.1.4
-
None
Description
The KB currently says that the following privileges are required for the MaxScale user account:
CREATE USER 'maxscale'@'%' IDENTIFIED BY 'maxscale_pw'; |
GRANT SELECT ON mysql.user TO 'maxscale'@'%'; |
GRANT SELECT ON mysql.db TO 'maxscale'@'%'; |
GRANT SELECT ON mysql.tables_priv TO 'maxscale'@'%'; |
GRANT SELECT ON mysql.columns_priv TO 'maxscale'@'%'; |
GRANT SELECT ON mysql.proxies_priv TO 'maxscale'@'%'; |
GRANT SELECT ON mysql.roles_mapping TO 'maxscale'@'%'; |
GRANT SHOW DATABASES ON *.* TO 'maxscale'@'%'; |
It looks like the following privilege also needs to be added:
GRANT SELECT ON mysql.procs_priv TO 'maxscale'@'%'; |
This privilege is currently missing on the following KB pages:
- https://mariadb.com/kb/en/mariadb-maxscale-6-setting-up-mariadb-maxscale/#creating-a-user-account-for-maxscale
- https://mariadb.com/kb/en/mariadb-maxscale-25-setting-up-mariadb-maxscale/#creating-a-user-account-for-maxscale
The privilege is already correctly shown on the following KB pages: