In T254795, I only requested a single user for XHGui, based on the permissions needed by the tool itself.
After going live, it's become apparent that we would benefit from an additional user, with some broader permissions, for debugging and manual tasks like schema upgrades and fixing corrupt data.
We'd thus like to add an 'xhguiadmin' user, with ALTER, CREATE, DELETE, INSERT, SELECT, and UPDATE privileges. (If ALTER is dangerous wrt replication, you can omit it, and we'll request help from a DBA if we ever need to drop/modify columns in the future.)
From the existing 'xhgui' user, you can remove CREATE (it was only needed initially) and DELETE (we've disabled the ability to delete profiles in our environment).
Please allow connections as this user from the same hosts as 'xhgui'.
You can assign it a random password.
- Creating new user T260640#6405475
- Revoking CREATE and DELETE