Veritas NetBackup™ for MySQL Administrator's Guide

Authenticating the password

Authenticating the password keeps you from specifying the password every time you run a backup. The my.cnf or the my.ini file stores the authentication credentials that the agent reads when it connects to the MySQL Server. Ensure that you store the password in the MySQL environment variable.

The MySQL utility to encrypt the password lets you set, reset, and validate the password. The utility for password encryption uses the port number to create a section name that corresponds to the instance to which the password belongs.

In MySQL v5.5.x, it reads the plain text authentication credentials from MySQL configuration file my.cnf. To authenticate, under the client section, edit the my.cnf, or my.ini file to add the password. For example:

[client]

port=3306

password= type the password

In MySQL v5.6 and later, it reads the encrypted authentication credentials from the MySQL options .mylogin.cnf file.