Install Guide

b. Right-click TCP/IP and select Enable.

7. Restart SQL Server.

a. In the navigation pane, click SQL Server Services.

b. Right-click SQL Server and select Restart.

Prepare a MySQL Database

Set up the database permissions for the Data Collector.

1. If necessary, install the database software.

2. Make sure that you have administrator rights from remote servers (preferably root user).

3. Make sure the database admin user has the global CREATE USER, RELOAD, and SELECT permissions, and has full permissions

to the compmsadb database.

Enter the following commands from the MySQL admin tool, where root is the name of the admin user:

• grant create user, reload, select on *.* to 'root'@'%';

• grant all privileges on compmsadb.* to 'root'@'%' with grant option;

• flush privileges;

Planning and Preparation