Configure MySQL User Password

From the CA NFA 10.0.1 release, you can manage the MySQL user password using the NFA MySQL User Password Change Utility. You must change the MySQL user password in CA NFA Harvester and in the CA NFA console. Ensure that the password for a user is same in both CA NFA Harvester and CA NFA Console.
nfa1000
From the CA NFA 10.0.1 release, you can manage the MySQL user password using the NFA MySQL User Password Change Utility. You must change the MySQL user password in CA NFA Harvester and in the CA NFA console. Ensure that the password for a user is same in both CA NFA Harvester and CA NFA Console.
Follow these steps:
  1. In the CA NFA Harvester server and CA NFA Console, navigate to
    <CA_NFA_HOME>\Tools
    directory.
  2. Stop the CA NFA services using the following commands:
    Windows:
    Harvester: harvester_services.bat stop
    Console: console_services.bat stop
    Linux:
    Harvester: harvester-services.sh stop
  3. Open the 
    DBPasswordUtils.exe
    file.
    A command prompt opens to let you change the password.
  4. At the prompt, select the user for which you intend to change the password.
    Select the DB User to change the Password
    1. netqos
    2. harvest
    3. archive
    4. Exit
    Enter your choice (No.):
    The utility displays the conditions to set the password.
  5. At the prompt, enter the required password:
    Enter the Password for <selected_user_name> DB User :
    The utility sets the desired password for the selected user.
  6. (Optional) Repeat the steps to set password for more users.
  7. At the prompt, select option to exit the command prompt.
  8. Restart the CA NFA services using the following commands:
    Windows:
    Harvester: harvester_services.bat start
    Console: console_services.bat start
    Linux:
    Harvester: harvester-services.sh start
  9. Restart the IIS server using the
    iisreset
    command.
    You have changed the MySQL password for the selected users.
More Information:
 For more information about troubleshooting any connection issues with CA Anomaly Detector, see CA NFA and CA Anomaly Detector Connection Issue.