If you want to create a special user for use with Ottomatik and are wondering what permissions are needed here they are.
Before you start, please note:
Please consider changing "YOUR_PASSWORD_HERE" string with your desired password
Note that the "dump"@"%" user/host is just an example, you can set that to whatever fits your needs.
Let’s start by making a new user within the MySQL shell:
CREATE USER 'dump'@'%' IDENTIFIED BY 'YOUR_PASSWORD_HERE';
MySQL backup permissions:
GRANT SELECT, USAGE, LOCK TABLES, SHOW VIEW, RELOAD, EVENT, TRIGGER, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'dump'@'%'
FLUSH PRIVILEGES;
Restore permissions (super required to disable/enable binary logging during restore):
GRANT SUPER, DROP, CREATE, UPDATE, ALTER, INDEX, CREATE ROUTINE, ALTER ROUTINE, INSERT, EXECUTE ON *.* TO 'dump'@'%';
FLUSH PRIVILEGES;
🎉🎉🎉
We hope you find this helpful! If you need any further assistance, please contact us and we'll be more than glad to help you out.