What MySQL permissions are needed? | Ottomatik

What MySQL permissions are needed?

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 premissions (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.