Things to know before you protect MySQL instances and databases
Protection plans can be used to predefine backup policies which are then used by others to protect their data. The following table describes the permissions with which MySQL database non-root user must be created:
Note:
Ensure that MySQL instance is on the InnoDB storage engine.
Table: User Privileges
User | Privileges |
|---|---|
Instance Superuser or Administrator | Select, Insert, Update, Create, Drop, Reload, Shutdown, File, Index, Alter, Super, Lock Tables, Create View, Show View, Trigger, Process, System_User, Create Routine, Delete, Event, Alter Routine |
To set the database user privileges, run the following command at MySQL command line:
GRANT SELECT, INSERT, UPDATE, CREATE, DROP, RELOAD, SHUTDOWN, FILE, INDEX, ALTER, SUPER, LOCK TABLES, CREATE VIEW, SHOW VIEW, TRIGGER, PROCESS, SYSTEM_USER, CREATE ROUTINE, DELETE, EVENT, ALTER ROUTINE ON *.* TO 'USER'@'localhost' IDENTIFIED BY 'PASSWORD'