Changing database passwords in Management Station
This topic is for MySQL and SQL server databases.
If you change the password for the Management Station database user after installing Speech Suite, you need to update Management Station with the new password:
- Open a command-prompt window and change to $MSTATION_HOME/mserver/webapps/mserver/scripts.
- Run the update-external-db-password script.
Windows:
update-external-db-password
Linux:
./update-external-db-password.sh
The script prompts for the new password, and restarts Management Station services.
- Log in to Management Station. Expect the services to be back online after a few seconds.
If you deployed an audit database, the script detects whether the account names is different from the primary database and asks which password you want to change. (By default, the databases share the same username and password, and the new password applies to both.)
Note: The purpose of the script is to update the encrypted database password for the Management Station user in the mserver_cfg.properties file. Use it after modifying the MySQL user password for the Management Station account. In mserver_cfg.properties update the password for mserver, mserversa, and mserverdc so these applications can connect to the database.
To change the password in MySQL,
-
Start a MySQL session and log in as the root user
-
Modify the MySQL user password for all four 'ms'@'host' combinations (with host represented as hostname, a fully qualified host name, an IP address, and localhost)
Here is an example sequence of commands. Repeat the sequence for each 'ms'@'host' combination using the same password for the given host:
[root@mt-ce-cor-linux-5 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 52
Server version: 5.8.00 MySQL Community Server (GPL)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> ALTER USER 'ms'@'localhost' IDENTIFIED BY 'NEW_USER_PASSWORD'; //replace NEW_USER_PASSWORD with your new password
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.01 sec)