...
Changing the Password in MySQL
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.
Enter the following command to connect to the database:
Code Block language sql mysql -uuptime -puptime -P3308 --protocol=tcp uptime
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.
Type the following command to log out of MySQL:
Code Block language sql exit;
Changing the Password in MS SQL or Oracle
- Open the desired db client to connect to the up.time database in MS SQL or Oracle.
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;