How to Discover MySQL Databases by SQL

This task describes how to discover the MySQL databases by SQL and includes the following steps:

1. Prerequisites - Set up protocol credentials

   This discovery uses the Generic DB Protocol (SQL).

   For credential information, see Supported Protocols.

2. Run the discovery

   1. Run the Databases TCP Ports job to verify the user name, password, and port used by the MySQL Database Server.

   2. Run the MySQL Connection by SQL job to connect to MySQL databases.

   3. Run the MySQL Topology by SQL job to discover MySQL database instances.

   For details on running jobs, refer to "Module/Job-Based Discovery" in the Universal CMDB Data Flow Management section of the UCMDB Online Help.