Provide mechanism to grant dynamic privilege to the utility user.

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