NetBackup™ Web UI MySQL Administrator's Guide
- Overview
- Managing MySQL instances and databases
- Managing MySQL environment credentials
- Protecting MySQL instances and databases
- Restoring MySQL instances and databases
- Troubleshooting MySQL operations
- Troubleshooting tips for NetBackup for MySQL
- Error during MySQL credential addition
- Error during the MySQL instances and databases discovery phase
- Error during the MySQL Protection Plan Creation
- Error while subscribing protection plan to MySQL asset
- Error while removing MySQL asset
- Error while backup of MySQL asset
- Error while restoring MySQL asset image
- API for MySQL instances and databases
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:
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'