Page History

...

Changing the 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 text
   cd <uptime_dir>/mysql/bin

   where <uptime_dir> is the directory in which up.time 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 up.time.
   
   

4. Type the following command to log out of MySQL:

   Code Block
   language sql
   exit;

Changing the Password in MS SQL or Oracle

1. Open the desired db client to connect to the up.time database in MS SQL or Oracle.

2. In the query window, enter the following statements to change the admin user's password to "uptime":

   Code Block
   language sql
   UPDATE users SET password = '6772c61c438ad4ab8964f628de685f4879c55f55'

   
   

   WHERE username = 'admin';

   COMMIT;