Reset the STA Database Root, Reports, or DBA Account Password

Follow this procedure to reset any of the following STA database accounts:

Caution – Do NOT use this procedure to reset the STA Database Application Account password. See the separate procedure, “Reset the STA Database Application Account Password”.

Note – The STA Database Root Account password should be changed by the MySQL database administrator.

# mysql -uroot  -p
Password: root-password

mysql> use mysql;

mysql> select distinct(user) from user order by user;

+---------+

| user    |

+---------+

|         |

| root    |

| staapp  |

| stadba  |

| starpts |

+---------+

5 rows in set (0.00 sec)

Note – Replace new-password with the actual new password. Replace user-ID with the actual STA database root, reports, or DBA account username. Use single quotes around these variables.

mysql> update user set password=PASSWORD('new-password') where user='user-ID';

mysql> commit;

mysql> flush privileges;

Caution – Be sure to make a note of the password you just entered.

mysql> quit;