search cancel

Unable to change Spectrum MySQL root password


Article ID: 255864


Updated On:


CA Spectrum


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

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


Spectrum 21.2.8 and Higher


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


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

           ./ -u root -p <password>

           replace <password> with your new password.

ex: ./ -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: