Preparing MySQL database for discovery and data collection

Before installation you need to prepare the MySQL Databases to be discovered.

The following procedure describes how to create an unprivileged account to be use by the SolutionPack.

Procedure

1. Identify the Collector IP or FQDN.
2. Connect to one of the MySQL databases and get and generate a non-plain text password using the command below:
   SELECT PASSWORD('mypass');
3. Take the result string (for example: *6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4) and grant the privileges on each of your databases as shown in the example below:

   CREATE USER 'watch4net'@'%'IDENTIFIED BY PASSWORD *6C8989366EAF75BB670AD8EA7A7FC1176A95CEF4;
   GRANT ALL ON *.* TO 'watch4net'@'%';