What are the steps to change the Portal MySQL password?
Dx NetOps Performance Management any version
To change the mysql password you can use the reset_mysql_password.sh script
The script is in /opt/CA/MySql/scripts
# ./reset_mysql_password.sh -h
Usage: ./reset_mysql_password.sh [[-p '<password>' | -pa] [-n '<newpassword>' | -na]] | [-f '<password>' | -fa]
Options:
-h Display this help and exit.
-p Existing password to connect to the database.
-pa Prompts for existing password to connect to the database.
-n New password to be updated for the db user (for localhost and %).
-na Prompts for new password to be updated for the db user (for localhost and %).
-f Forcibly reset unknown password using MySQL init-file option.
-fa Prompts for password to forcibly reset unknown password using MySQL init-file option.
NOTE: Normal password change requires MySQL be running.
NOTE: Force reset option requires root permissions to be able to stop/start mysqld!!!