Changing the App Visibility database password
For each App Visibility portal or collector component, you can modify the MySQL root password. The password is required when you need to backup, restore, and perform other maintenance tasks on the database.
If the App Visibility portal and the App Visibility collector are installed on the same host, and thus use the same database, changing the password affects both components, regardless of which script you use to change the password.
To change the MySQL root password
- At a command line on the App Visibility server, navigate to the following directory:
- Windows
installationDirectory\portal\bin\db
or
installationDirectory\collector\bin\db
The default installationDirectory is C:\Program Files\BMC Software\App Visibility - Linux
installationDirectory\portal\bin\db
or
installationDirectory\collector\bin\db
The default installationDirectory is /opt/bmc/app_visibility
- Windows
- Enter the following command:
- Windows
change-db-root-password.bat - Linux
change-db-root-password.sh
- Windows
- At the Enter password prompt, enter the current password.
The default password is admysql. - At the New password prompt, enter a new password, using a strong password that comprises the following:
- A minimum of 10 characters
- Two of the following nonalphabetic characters that are noncontiguous:
0 1 2 3 4 5 6 7 8 9 ~ ! @ # $ % ^ & * ( ) _ + - =
- At the Confirm password prompt, enter the new password again.
Related topic
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*