I’ve just setup percona cluster 5.7 in k8s, using the percona operator.
Everything seems to be fine, except that, although I can use the root user to create new users, I can not grant them privileges.
I’ve setup only 1 replica, so this is not a replication issue.
Im doing this from a dummy webpage:
[host] => dummy-app-cluster-haproxy [user] => root [pass] => root_password [sql] => GRANT ALL PRIVILEGES ON test.* TO 'server'@'%';
Where ‘server’ is the new user that is already created.
Any ideas on what the problem might be?