How to change the RUM MySQL Database User Password

  • KM01794677
  • 24-Aug-2015
  • 24-Aug-2015

Summary

steps to change the mySQL DB User Password

Question

 When the MySQL database is created during RUM installation, a user name and password is created.

 

Answer

To change the MySQL database user password:

1. Ensure that the RUM Engine is stopped. If not, on the machine on which the RUM Engine is installed, select Start > Programs > HP Real User Monitor > Administration > Disable HP Real User Monitor.

 2. From a Windows Command Prompt window, login to the MySQL console.

3. Connect to the SQL database using your current user name and password. C:\\MySQL\bin>mysql -h localhost --user=user_name -p

4. Show the available database schemas:

mysql> show databases

5. Access your database schema:

 mysql>use rumdb234;

6. Create new password for the selected MySQL database schema:

mysql> set password for 'rum_user'@'localhost' = PASSWORD('new_password');

7. Close the Windows Command Prompt window.

8. Run the RUM configuration wizard. On the machine on which the RUM Engine is installed, select Start > Programs > HP Real User Monitor > Administration > RUM Configuration Tool. Real User Monitor Administration .

9. On the Connect to Database page, select Connect to RUM database.

10. On the MySQL Database Properties page, enter the new password