Authenticating the MariaDB environment password
Authenticating the MariaDB environment password keeps you from specifying the password every time you run a backup. The (Windows) my.ini file and the (Linux) my.cnf file stores the password and the application picks the password every time you run a backup.
Authenticating the password
The agent reads the plaintext authentication credentials from the my.cnf file in Linux and my.ini file in Windows.
Prerequisites
Before you authenticate the password, you must meet the following prerequisites:
(Windows) Set the user environment variable
MYSQL_HOMEto point tomy.inifile path.(Linux) Include the
Mariadbbin directory in$PATH.
To authenticate the password
- (Optional) Add the client section.
- Under the Client section, edit the
my.iniormy.cnffile to add the password. For example,[client]
port=3306
password=<password>
- To verify the password authentication, login to MariaDB server using the following command:
mysql -u <user>