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.
The agent reads the plaintext authentication credentials from the my.cnf file in Linux and my.ini file in Windows.
Before you authenticate the password, you must meet the following prerequisites:
(Windows) Set the user environment variable
NBMARIADB_CNF_<port>to point tomy.inifile.(Linux) Set the user environment variable
NBMARIADB_CNF_<port>to point tomy.cnffile. and include the Mariadb bin directory in $PATH.
To authenticate the password
- Add the client section.
- Under the Client section, edit the
my.iniormy.cnffile to add the password. For example,[client]
port=3306
password=<password>
Note:
If password is not added under client section, then you can mention the section name using NBMARIADB_CNF_SECTION_<port>.
Note:
For this environment variable, specify NBMARIADB_CNF_<port> variable.
For example:
For Linux, use command: echo "export NBMARIADB_CNF_SECTION_3306=instance1" >> ~/.bashrc
For windows, user can create new environment variable and add name of section as: NBMARIADB_CNF_SECTION_3306=instance1
- To verify the password authentication, login to MariaDB server using the following command:
mysql -u <user>