Changing the portal mysql password

Products

• Network Observability
• CA Performance Management

Issue/Introduction

What are the steps to change the Portal MySQL password?

Environment

Dx NetOps Performance Management any version

Resolution

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!!!

Additional Information

reset_mysql_password.sh

 

The reset_mysql_password.sh script updates the MySQL password for root and netqos accounts.