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?