Automate Root Password Reset/Recovery utility

Introduction #

Connectwise Automate uses the root account in MySQL to allow the Database Agent service to interact with the database. It stores the credentials in an encrypted format in the registry, which means that the credentials must be updated synchronously in both places. To aid in this process, the Automation Theory Automate Root Password Reset/Recovery utility can be used.

Requirements #

  • Working existing credentials (Database Agent service must be working, can’t be used after a failed manual rotation)
  • Latest version of .Net Framework (compiled for version 4.7.2)
  • Latest C++ redistributable (contains Oracle MySQL connector, which requires version 2022)

Usage Instructions #

  1. Download the utility from the email link, and unblock in file properties as needed.
  2. Run the utility as an administrator (it must access the registry and restart services, so administrator permissions are required).
  3. Paste in the license code and click the Unlock button.
  4. To view the current MySQL root password, click the “Show MySQL root password” button.
  5. To update the root password, enter a new password into the password field, and click the “Change Root Password” button.
  6. If the rotation is successful, the utility will prompt to restart the Database Agent service. It should be restarted immediately; click Yes on the prompt to restart
    .This image has an empty alt attribute; its file name is image.png
  7. After the service restarts, the utility will display a confirmation message:This image has an empty alt attribute; its file name is image-1.png
  8. After the rotation process is done, the option to show the root password should display the new password.