Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 6.1.4
-
Fix Version/s: 2.5.17
-
Component/s: Authenticator, Documentation
-
Labels: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: