NFA Password Reset steps for Mysql database till version 10250

NFA Password Reset steps for Mysql database till version 10250

Kindly follow steps as given below to reset the password. Please note that the NetFlow Analyzer Server is running before doing the below steps.

1. Open a command prompt

2. Go to the <NETFLOW_HOME>\mysql\bin directory

3. Type
For Windows    :   mysql -u root -P 13310
For Linux        :   ./mysql -u root -P 13310 -S ../tmp/mysql.sock

4. Type use netflow;

5. Execute the following query:

update AaaPassword, AaaLogin, AaaAccount, AaaAccPassword set
AaaPassword.PASSWORD='Ok6/FqR5WtJY5UCLrnvjQQ==', AaaPassword.SALT='12345678'
where AaaLogin.LOGIN_ID = AaaAccount.LOGIN_ID and AaaAccount.ACCOUNT_ID =
AaaAccPassword.ACCOUNT_ID and AaaPassword.PASSWORD_ID =
AaaAccPassword.PASSWORD_ID and AaaLogin.NAME = 'admin' ;


6. Type quit to quit mysql

7. Type exit to exit command prompt

8. Login as admin / admin. You can change the password again if you wish


          • Related Articles

          • NFA Password reset for pgsql database till version 11001

            Kindly follow steps as given below to reset the password. Note : Make sure that NetFlow Analyzer Service is running before following the below steps 1. Open a command prompt 2. Go to the <NETFLOW_HOME>\pgsql\bin directory 3. Type For Windows    :   ...
          • NFA and NCM 12 Default Admin password Reset_postgres Database

            Please follow the below steps to Reset password to default for the local admin user in NetFlow Analyzer / Network Configuration Manager / Firewall Aanlyzer : Download and unzip ResetPassword script and place the file named ResetPassword.bat and ...
          • Admin Password Reset for NetFlow Analzer with database MSSQL till build 11001

            1. Open the Management Studio on the MSSQL server 2. Select the netFlow database. Right click on netflow database and click on New Query 3. Execute the following query update AaaPassword set PASSWORD='Ok6/FqR5WtJY5UCLrnvjQQ==', SALT='12345678' from ...
          • Firewall Analyzer Mysql to Pgsql migration steps.

            Stop the Firewall Analyzer Service. Take the backup or a VM snapshot of ManageEngine\Firewall folder. Download the correct zip files based on your OS(32/64bit) from the below link and extract it under <Firewall Analyzer Home>. ...
          • Steps to add password to postgres database in NFA12 & NCM12

            1) Start OpManager service 2)Connect  to OpManager database :   a)Go to OpManager\pgsql\bin folder   b)Type psql -U postgres -h 127.0.0.1 -p13306  OpManagerDB   c)Once connected to the Database, execute the below query to set password          ALTER ...