Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-7127

Provide mechanism to grant dynamic privilege to the utility user.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 8.0.x, Not 5.6.x, Not 5.7.x
    • Fix Version/s: 8.0.20-11
    • Component/s: None
    • Labels:
    • Needs Review:
      Yes
    • Needs Doc:
      Yes

      Description

      We are trying to use Utitlity user as admin for our PXC Operator. But we found a bug that don't allow us to do this.

      Our setup is:

      utility_user=operatoradmin@%
      utility_user_schema_access=information_schema,mysql,sys
      utility_user_password='operatorpass'
      utility_user_privileges="SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,RELOAD,SHUTDOWN,PROCESS,FILE,GRANT,REFERENCES,INDEX,ALTER,SHOW DATABASES,SUPER,CREATE TEMPORARY TABLES,LOCK TABLES,EXECUTE,REPLICATION SLAVE,REPLICATION CLIENT,CREATE VIEW,SHOW VIEW,CREATE ROUTINE,ALTER ROUTINE,CREATE USER,EVENT,TRIGGER,CREATE TABLESPACE"

       

      But when we try to change password for 'root'@'localhost' user there is an error

      mysql -h 127.0.0.1 -P 3306 -uoperatoradmin -p
       
      mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'newpass';
      ERROR 1227 (42000): Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation

       

      If user not 'localhost' everything goes well

       

        Attachments

          Activity

            People

            Assignee:
            kamil.holubicki Kamil Holubicki
            Reporter:
            max.dudin Maksim Dudin
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Time Spent - 2 days, 6 hours, 48 minutes Remaining Estimate - 2 hours, 22 minutes
                2h 22m
                Logged:
                Time Spent - 2 days, 6 hours, 48 minutes Remaining Estimate - 2 hours, 22 minutes
                2d 6h 48m

                  Smart Checklist