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


                New to ADManager Plus?

                  New to ADSelfService Plus?

                    • 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

                      Forgot Password: The Forgot Password option in the login page can be used to reset the password. Make sure the Mail Server Settings and User's email ID are configured. The auto generated password will be sent to the email ID entered as the User's ...
                    • 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 ...