All Collections
Backups
What MySQL permissions are needed?
What MySQL permissions are needed?
Brent Sanders avatar
Written by Brent Sanders
Updated over a week ago

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.Β 

Did this answer your question?