After running mysql_config_editor Archive Manager and DDMDB Backups are failing
Article ID: 145293
After running the mysql_config_editor on our Spectrum installation ddm_backup and ddm_save fails to run with access denied errors.
The password set using the mysql_config_editor is wrong.
Just run it again and specify the right password.
1. Navigate into $SPECROOT/mysql/bin as the "caadmin" user.
./mysql_config_editor set --login-path=client --host=localhost --user=spectrum --password
./mysql_config_editor set --login-path=client --host=localhost --user=caadmin --password
Enter caadmin as the password.
Your applications should start working successfully.
Change user to the user ID used to install Spectrum.
By default the username and password are the same. So "caadmin" would be the password set.