To reset the root password for the MySQL database component of Network Security Manager:
- Click Start, Programs, Administrative Tools, Services.
- 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.
- 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:
- Click Start, Programs, Administrative Tools, Services.
- 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