Changing the MySQL root password for BMC Application Diagnostics systems

The MySQL database is created with the default root password admysql.

On each computer with a BMC Application Diagnostics 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 BMC Application Diagnostics Portal and the BMC Application Diagnostics Collector are installed on the same host, both the portal and collector databases are affected by changing the password, regardless of which script you use to change the password.

To change the MySQL root password

1. At a command line, navigate to the following directory on the BMC Application Diagnostics Server:
   • Windows
     installationDirectory\portal\bin\db
     or
     installationDirectory\collector\bin\db
     

     The default installationDirectory is C:\Program Files\BMC Software\BMC Application Diagnostics

   • Linux
     installationDirectory\portal\bin\db
     or
     installationDirectory\collector\bin\db
     

     The default installationDirectory is /opt/bmc/BMC_Application_Diagnostics

2. Enter the following command:
   • Windows
     change-db-root-password.bat
   • Linux
     change-db-root-password.sh
3. At the Enter password prompt, enter the current password. The default password is admysql.
4. 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 ~ ! @ # $ % ^ & * ( ) _ + - =

5. At the Confirm password prompt, enter the new password again.