Page History

...

Changing the password in MySQL

To change the UIM admin password in MySQL

1. At the command prompt, enter the following command to change to the directory in which the database is installed:
   

   Code Block
   language sql
   cd <uptime_dir>/mysql/bin

   where <uptime_dir> is the directory in which Uptime Infrastructure Monitor is installed.
2. Enter the following command to connect to the database:
   

   Code Block
   language sql
   mysql -uuptime -puptime -P3308 --protocol=tcp uptime

3. At the MySQL prompt, enter the following statement to change the admin user's password:
   

   Code Block
   language sql
   UPDATE users SET password = SHA1("NEWPASSWORD") WHERE username = "admin";

   where NEWPASSWORD is the updated password for the admin user in Uptime Infrastructure Monitor.
4. Type the following command to log out of MySQL:
   

   Code Block
   language sql
   exit;

Changing the password in MS SQL or Oracle

To change the UIM admin password in MS SQL or Oracle

...