Reset the Controller Database Root User Password

To reset the Controller Database root user password:

  1. Log in to the RDS instance as admin:
    1. ./mysql -u admin -h <rds-aurora-endpoint> -P 3388 -p
  2. Use MySQL to run the commands:
    1. To specify the Controller database, enter: use mysql;
    2. To reload the MySQL grant tables, enter:FLUSH PRIVILEGES;
    3. To determine your MySQL version, enter:select version();
    4. If you are using MySQL version 5.5, to configure the new password for the root user, enter: update mysql.user set password=password('<new-password-here>') where user like 'root%';
    5. If you are using MySQL version 5.7. to configure the new password for the root user, enter: update mysql.user set authentication_string=password('<new-password-here>') where user like 'root%';
    6. To reload the MySQL grant tables, enter: FLUSH PRIVILEGES;
    7. To exit MySQL, enter: quit