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
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