Mysql> select * from er WHERE User = 'server' OR User = 'root' Mysql> GRANT ALL PRIVILEGES ON test.* TO OK, 0 rows affected (0.01 sec) Grants for GRANT ALL PRIVILEGES ON *.* TO WITH GRANT OPTION Here what I got from the terminal: mysql> show grants\G Grants for GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES, INDEX, ALTER, SHOW DATABASES, SUPER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE TABLESPACE, CREATE ROLE, DROP ROLE ON *.* TO WITH GRANT OPTION If you can show us the output of show grants when logged in as root that would help us diagnose this further. I just checked on my PXC Operator v1.7 environment (PXC 8.0.21) and it shows that my root user has the GRANT option, meaning root can assign privs to other users. Can you show us the error that is returned when you run the GRANT statement?
