Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

[ppcharli]

dolphie -V

3.1.3

mysql -V

mysql Ver 8.0.33-25.1 for Linux on x86_64 (Percona XtraDB Cluster (GPL), Release rel25, Revision 0c56202, WSREP version 26.1.4.3)

dolphie -u root -h localhost

Error ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ Failed to execute query / dolphie / SELECT NAME, COUNT FROM information_schema.INNODB_METRICS WHERE name IN ('adaptive_hash_searches', 'adaptive_hash_searches_btree', 'trx_rseg_history_len') Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

However, executing the same query with mysql works

mysql -u root -h localhost

mysql> SELECT -> NAME, -> COUNT -> FROM -> information_schema.INNODB_METRICS -> WHERE -> name IN ('adaptive_hash_searches', 'adaptive_hash_searches_btree', 'trx_rseg_history_len'); +------------------------------+-------+ | NAME | COUNT | +------------------------------+-------+ | trx_rseg_history_len | 0 | | adaptive_hash_searches | 35910 | | adaptive_hash_searches_btree | 64100 | +------------------------------+-------+ 3 rows in set (0.01 sec)

Thanks,

[charles-001]

Hi @ppcharli - thanks for your bug report! That's a strange issue as I've never seen this happen before. Since you're connecting from root, I'd assume it has full privileges. Can you try and create a new user and try with that?

[ppcharli]

Hi, creating another user works fine Thanks

[charles-001]

Gotcha - must be something with your root user then. Glad it's working now :)