Unable to change Spectrum MySQL root password

Products

• CA Spectrum

Issue/Introduction

After Upgrading Spectrum to 22.2.3.0.15 Getting below error while trying to change Spectrum MySQL root password

"ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)" 

Environment

Spectrum 21.2.8 and Higher

Cause

From 21.2.8, have to use "./update_mysql_user.pl" command to update the password.

Resolution

Follow below steps to change the default root password for the MySQL root user.

1. Export the configuration file using the following command:

     export MYSQL_TEST_LOGIN_FILE=/$SPECROOT/mysql/data/mylogin.cnf

2. Run the following command to change the existing password:

    ./mysql_config_editor set --login-path=myclient --host=localhost --user=root --password

3. At the prompt, enter the new password.

    Enter password:

4.Update MySQl user password.

•     Navigate to $SPECROOT/mysql/bin and run the

           ./update_mysql_user.pl -u root -p <password>

           replace <password> with your new password.

ex: ./update_mysql_user.pl -u root -p MySqlroot

NOTE: This Update command will restart the Tomcat and ArchiveManager processes.

Now Password will be updated successfully.
Try to login into MySQL using new password

 

Additional Information

Update password:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/spectrum/22-2/administrating/database-management/Update-MySQL-User-Passwords.html