'percona_schema mysql.pxc.sst.role@localhost', It will not be possible to remove this privilege using REVOKE

MySQL & MariaDB Percona XtraDB Cluster 8.x
1

I am running a MySQL xtradb cluster with percona/percona-xtradb-cluster:8.0.31-23.1.
I have created the new cluster with the option “lower_case_table_names = 1”

Everything is running fine, but when I do a “FLUSH PRIVILEGES;” I get a warning in the logging.

2023-04-14T15:18:42.536240-00:00 18 [Warning] [MY-010324] [Server] ‘db’ entry ‘percona_schema mysql.pxc.sst.role@localhost’ had database in mixed case that has been forced to lowercase because lower_case_table_names is set. It will not be possible to remove this privilege using REVOKE.

It is a Warning, so I do not worry a lot, but is there a setting to prevent this?

2

Hi @doets001

If you were able to build the cluster completely, then there is not any problem. Usually, during the cluster setup, it is necessary to perform several SST operations.

In any case, this should be fixed. It would be great if you could fill a bug in our Jira? https://jira.percona.com/

Thank you!

3

ok, thnx, for now I will ignore this warning and I will log a bug.