Related \nDocumentation | \nVersion \nof up.time Affected | \nAffected Platforms | \n
\n |
\n All | \nAll | \n
Database Users
\n \nThe default up.time installation is configured with the following MySQL users:
\n \nThe root user has complete control over the database.
\nThe 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.
\n \nThe 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.
\n \nFor information on setting up an ODBC \ndriver, see Connecting to the up.time DataStore via ODBC. \n
Change Passwords for the Default Users
\n \nThe default passwords for the three up.time user accounts should be changed by following these steps:
\n \nmysql -uroot -puptimerocks -P3308 --protocol=tcp
\nmysql> SET \nPASSWORD FOR `user'@'localhost' = PASSWORD (new_password);
\n \nSET \nPASSWORD FOR `user'@'domain_name' = PASSWORD (new_password);
\n \n