Page History

Database Users 

...

Database Users

...

The default up.time installation is configured with the following MySQL users:

...

• root (password: uptimerocks)
\n

The root user has complete control over the database.

...

• uptime (password: uptime)
\n

The uptime user is a privileged local user who can create, delete, flush and drop tables; create and delete table indices; and select, insert and delete data in tables. This user can not login remotely or perform administrative tasks such as creating MySQL users or killing threads.

...

• reports (password: reports)
\n

The reports user can remotely perform queries in the up.time DataStore and may be used by an up.time Reporting Instance or by a third party reporting tool that connects to up.time via ODBC.

...

For information on setting up an ODBC

...

driver, see Connecting to the up.time DataStore via ODBC.

...

...

Change Passwords for the Default Users

...

The default passwords for the three up.time user accounts should be changed by following these steps:

...

1. At the command

   \nprompt

   prompt on the monitoring station, login to MySQL as the root user by typing:

   
   \n \n

   Code Block
   language text
   mysql -uroot -puptimerocks -P3308 --protocol=tcp

   \n
   

   where: uptimerocks is the password for the root user

\n \n

3. Next, change the password by typing:

   
   \n \n

   Code Block
   language sql
   mysql> SET

   \nPASSWORD

   PASSWORD FOR `user'@'localhost' = PASSWORD (new_password);

   \n \n
   

   where:

   \n
   \n
   • SET PASSWORD \nis is the MySQL command that assigns or changes a password to a user account.
   \n
   • user is the user name for which you want to change the password.
   \n
   • PASSWORD (); \nis is the MySQL function that encrypts the new password.
   \n
   • new_password \nis is the updated password.
   \n
   \n \n
4. Repeat the SET PASSWORD statement for each MySQL user listed in the up.time user guide.
\n

5. If you want to

   \nlimit

   limit the domains from which users can access the database, type the following command:

   
   \n \n
   SET \nPASSWORD FOR

   Code Block
   language sql
   SET PASSWORD FOR `user'@'domain_name' = PASSWORD (new_password);

   \n \n
   

   where: domain_name is the domain or IP address from which the user will be allowed to access the database (if the user attempts to access the database from a

   \ndifferent

   different domain or IP address, that user will not be able to log in).

\n