The default Uptime Infrastructure Monitor installation includes a bundled MySQL database. There are several scenarios in which it may be desirable to implement a dedicated database server. This article provides instructions for moving your datastore to the new remote host.
In the following example, Host1 is the current server and Host2 is the remote database server being installed.
Log into Host2's MySQL database using the following command:
...\uptime\mysql\bin\mysql -uroot -puptimerocks -P3308 --protocol=TCP |
At the MySQL prompt, execute the following command to grant remote access to the database:
grant all privileges on uptime.* to "uptime"@"%" identified by "uptime"; |
For additional security (to whitelist only Host1), replace % with the IP address or hostname of Host1. |