Self-Solve Knowledge Search

Minimize Maximize
How to change the RUM MySQL Database User Password
Title :
How to change the RUM MySQL Database User Password
Document ID :
KM01794677
Product - Version:
application performance management (bac) ;
OS :
Updated :
Mon Aug 24 09:45:26 GMT 2015
Summary :
steps to change the mySQL DB User Password

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

 

Solution

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