When upgrading an OSCharms 19.04 environment (cloud:xenial-queens) from Xenial to Bionic, I had to recover the Percona-Xtradb cluster from one of the units (seed).
I used innobackupex to get the data and copy it to the donors, but I hit the following error (on the seed):
"""
Error: failed to execute query SHOW ENGINE INNODB STATUS: Access denied; you need (at least one of) the PROCESS privilege(s) for this operation
"""
Issue was fixed after I manually ran:
"""
mysql> select user,host from user where user='sstuser';
+---------+---------------+
| user | host |
+---------+---------------+
| sstuser | ip6-localhost |
| sstuser | localhost |
+---------+---------------+
2 rows in set (0.00 sec)
mysql> show grants for sstuser@localhost;
+-------------------------------------------------------------------------------+
| Grants for sstuser@localhost |
+-------------------------------------------------------------------------------+
| GRANT RELOAD, LOCK TABLES, REPLICATION CLIENT ON *.* TO 'sstuser'@'localhost' |
+-------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> grant PROCESS on *.* to 'sstuser'@'localhost';
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
"""
The post-series-upgrade hook may need to grant such permission (not sure if "ON *.*" is what it would be needed, though).
Thank you.
Subscribing field-medium, this is still an active issue causing upgrade issues.