How to reset the root password for the MySQL database component of Network Security Manager

Technical Articles ID: KB66303
Last Modified: 3/26/2020

Environment

McAfee Network Security Manager (NSM) 9.x, 8.x

Summary

To reset the root password for the MySQL database component of Network Security Manager:

Click Start, Programs, Administrative Tools, Services.
1. Right-click the McAfee Network Security Manager Database service and select Stop.
2. Right-click the McAfee Network Security Manager and select Stop.
3. Right-click the McAfee Network Security Manager Watchdog services and select Stop.
Double-click the McAfee Network Security Manager Database service and copy the path to the executable, excluding the final McAfeeNetworkSecurityManagerDatabase.
Click Start, Run, type cmd, and click OK.
Type or paste the copied path to the executable and add --skip-grant-tables.

For example:
- For 64-bit Windows Server System:
  "C:\Program Files\McAfee\Network Security Manager\MySQL\bin\mysqld" --defaults-file="C:/Program Files/McAfee/Network Security Manager/MySQL/my.ini" --skip-grant-tables
- For 32-bit Windows Server System:
  "C:\Program Files (x86)\McAfee\Network Security Manager\MySQL\bin\mysqld" --defaults-file="C:/Program Files (x86)/McAfee/Network Security Manager/MySQL/my.ini" --skip-grant-tables
Open a MySQL CLI session without authentication so it can be accessed in another window:
Type mysqld and press ENTER.
NOTE: If you have User Account Control enabled, you might receive the following error after this step:

InnoDB: The error means that mysqld does not have the access rights to
InnoDB: the directory. It may also be you have created a subdirectory
InnoDB: of the same name as a data file.
InnoDB: File name C:\Program Files (x86)\McAfee\Network Security Manager\MySQL\innodbdata\innodbdata1
InnoDB: File operation call: 'open'.

To resolve the issue, disable User Account Control and reboot.
Open a second command window:
Click Start, Run, type cmd, and click OK.
In the second window, navigate to:

<NSM installation DIR>\MySQL\bin
Type mysql.exe -u root and press ENTER.
The MySQL prompt is displayed.
Type use mysql and press ENTER.
Type the following command and press ENTER:

update user set password = PASSWORD('<newpassword>') where user = 'root';

NOTE: Replace <newpassword> with the password you want to use for the root account.
Type exit and press ENTER.
Type mysqladmin.exe shutdown and press ENTER.
When the first command console window returns to the command prompt, start the MySQL service:
1. Click Start, Programs, Administrative Tools, Services.
2. Right-click the McAfee Network Security Manager Database service and click Start.
Verify that you can connect to the MySQL database using the new password:
Type the following command at the <NSM installation DIR>\MySQL\bin prompt and press ENTER:

mysql.exe -u root -p

Affected Products

Configuration
Network Security Manager 9.1.x
Network Security Manager 8.1.x (EOL)
Password Recovery

Glossary of Technical Terms

Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.

Knowledge Center

How to reset the root password for the MySQL database component of Network Security Manager

Environment

Summary

Affected Products

Glossary of Technical Terms

Title

Title

Knowledge Center

How to reset the root password for the MySQL database component of Network Security Manager

Environment

Summary

Affected Products

Glossary of Technical Terms

Choose your region

Title

Title