If you want to create a special user for use with Ottomatik and are wondering what permissions are needed here they are.

mysql backup permissions:

GRANT SELECT, USAGE, LOCK TABLES, SHOW VIEW, RELOAD, EVENT, TRIGGER, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'dump'@'%' IDENTIFIED BY 'YOUR_PW_HERE';

restore permissions (super required to disable/enable binary logging during restore):

GRANT SUPER, DROP, CREATE, UPDATE, ALTER, INDEX, CREATE ROUTINE, ALTER ROUTINE, INSERT ON *.* TO 'dump'@'%' IDENTIFIED BY 'YOUR_PW_HERE';

FLUSH PRIVILEGES;

Note that the "dump"@"%" user/host is just an example, you can set that to whatever fits your needs.

🎉🎉🎉

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. 

Did this answer your question?