Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-3832

Document privileges required for procs_priv system table

    XMLWordPrintable

Details

    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:

      The privilege is already correctly shown on the following KB pages:

      Attachments

        Activity

          People

            markus makela markus makela
            GeoffMontee Geoff Montee (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.