To reset the root password for the
MariaDB database component of the Manager, perform the steps below:
- Click Start, Programs, Administrative Tools, Services.
- For versions 9.x and 10.1.9 and earlier:
- Right-click the McAfee Network Security Manager Database service and select Stop.
- Right-click the McAfee Network Security Manager and select Stop.
- Right-click the McAfee Network Security Manager Watchdog services and select Stop.
- For versions 10.x.1.10 and later, including 11.x:
- Right-click the Trellix IPS Manager Database service and select Stop.
- Right-click the Trellix IPS Manager and select Stop.
- Right-click the Trellix IPS Manager Watchdog services and select Stop.
- Double-click the <..> Manager Database service and copy the path to the executable, excluding the final McAfeeNetworkSecurityManagerDatabase or IntrusionPreventionSystemManagerDatabase.
- Open a command window:
Click Start, Run, type cmd, and click OK.
- Type or paste the copied path to the executable and add --skip-grant-tables.
For example:
C:\Program Files\Trellix\IPS Manager\MariaDB\bin>mariadbd.exe --skip-grant- tables
- Open a second command window in the same path, using the command mariadb.exe -u root
For example:
C:\Program Files\Trellix\IPS Manager\MariaDB\bin>mariadb.exe -u root
- Type use mysql; and press Enter.
- Type FLUSH PRIVILEGES; and press Enter.
- Type set password for root@localhost = password(‘<newpassword>’); and press Enter.
NOTE: Replace <newpassword> with the password that you want to use for the root account.
- Type exit and press Enter.
- Shut down the MariaDB process that you opened earlier:
Type mariadb-admin.exe -uroot -p shutdown and press Enter.
If prompted for a password, enter the new password that you set earlier.
- Start the Manager and Database services:
- Click Start, Programs, Administrative Tools, Services.
- Right-click the <...> Manager Database service and click Start.
- Verify that you can connect to the database using the new password:
Type the following command at the <Manager installation directory>\bin prompt and press Enter:
mariadb.exe -u root -p
