Post-installation requirements for NetBackup for MySQL Agent
After you install the agent
(Windows) Configure the NetBackup for MySQL Agent to run with administrative privileges.
(Windows) Add the
NetBackup bindirectory to the PATH user environment variable.(Linux) If the
nbmysql.conffile does not exist, create the default configuration file. For more information, See The nbmysql configuration file.(Linux) The user of the agent is a superuser or have superuser privileges.
(Linux) Symbolic link: If a symbolic link does not exists, create a symbolic link
libmysqlclient.soand ensure that it points tolibmysqlclient.so.<n>, wherenis the MySQL client library version . You can create the symbolic link at your chosen directory.For example, if the MySQL client library version is 18, then the symbolic link
libmysqlclient.sopoints tolibmysqlclient.so.18.Note:
Ensure that you update the MYSQL_LIB_INSTALL_PATH parameter in the
nbmysql.conffile with the absolute path of the symbolic link.Set the following user privileges:
Table: User privileges
User | Privileges |
|---|---|
Backup | LOCK TABLES, SELECT, FILE, RELOAD, SUPER, UPDATE, TRIGGER, SHOW, VIEW, EXECUTE, and EVENT. |
Restore | CREATE, DROP, INDEX, SHUTDOWN, INSERT, ALTER, DELETE, UPDATE, TRIGGER, SUPER, and CREATE VIEW. |
To set the user privileges, run the following commands:
GRANT SELECT, INSERT, UPDATE, CREATE, DROP, RELOAD, SHUTDOWN, FILE, INDEX, ALTER, SUPER, LOCK TABLES, CREATE VIEW, SHOW VIEW, TRIGGER, CREATE ROUTINE, DELETE, EVENT, ALTER ROUTINE ON *.* TO 'USER'@'localhost' IDENTIFIED BY 'PASSWORD'
For more information, see MySQL Administration Guide