---
sourceDocument: Yokohama IT Operations Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/it-operations-management

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama IT Operations Management

ft:clusterId :

    - itom

bundleId :

    - itom

workflow :

    - Technology


---

# MySQL

# MySQL discovery {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Discovery can identify an instance of MySQL that is running on UNIX or Windows operating systems.

## Requirements {#c_MySQLDiscovery__section_lnb_nvq_rz}

Discovery searches for the MySQL configuration file location from the following areas:

* UNIX: Discovery searches for the MySQL configuration file location from the mysqld process, or port 3306.
* Windows: Discovery searches for the MySQL configuration file location from the mysqld.exe process, or port 3306.
{#c_MySQLDiscovery__ul_dkn_ksb_1r} For each process, the following process parameters are explored in the following order:

--defaults-extra-file

--defaults-file  
If the MYSQL configuration file location is not found from that search, then the following occurs:

* UNIX: The configuration file location defaults to /etc/my.cnf.
* Windows: No default configuration file location exists, and the probe to read the configuration file location is skipped.

{#c_MySQLDiscovery__ul_ndl_rsb_1r}  
Note:  
For information on Probe to Pattern migration see the knowledge article [KB0694477](https://support.servicenow.com/kb_view.do?sysparm_article=KB0694477).

## Credentials {#c_MySQLDiscovery__section_f2y_ztq_rz}

Configure these credentials:

* [Windows credentials](https://www.servicenow.com/docs/access?context=r_WindowsCredentialsForm&version=yokohama&pubname=yokohama-platform-security&ft:locale=en-US)
* [SSH credentials](https://www.servicenow.com/docs/access?context=r_SSHCredentialsForm&version=yokohama&pubname=yokohama-platform-security&ft:locale=en-US)
* [Applicative credentials](https://www.servicenow.com/docs/access?context=applicative-creds&version=yokohama&pubname=yokohama-platform-security&ft:locale=en-US) (When applications require credentials in addition to the credentials the that host machine requires.)  
  Note:  
  There's no need to configure applicative credentials unless your Discovery prerequisites mention them.
{#c_MySQLDiscovery__ul_bbg_gqf_kcb}

For a list of privileged commands that you need for Discovery
and Service Mapping, see [Service Mapping commands requiring a privileged user](https://servicenow-prod.fluidtopics.net/KmX~uDsV3RoqnUbrW~2SFA "Service Mapping uses commands requiring elevated rights to discover and map Unix-based hosts in your organization. In addition to configuring necessary credentials, configure servers in your organization to allow Service Mapping to run these commands with elevated rights."). This list
includes commands that require elevated rights to discover and map Unix-based hosts in
your organization.

## Classifiers, patterns, and probes {#c_MySQLDiscovery__section_r2s_l5q_rz}

Discovery uses these classifiers, probes, and patterns for MySQL discovery:{#c_MySQLDiscovery__table_fzd_2yv_jz__entry__3}

| Classifier | Trigger probes | Pattern |
|-|-|-|
| MySQL Server | * Horizontal Pattern: launches patterns * Windows - MySQL Configuration\* * Windows - MySQL Version\* * MySQL - Configuration\* * MySQL - Version\* {#c_MySQLDiscovery__ul_ixv_myv_jz} | My SQL server On Windows and Linux Pattern |
[ ]

{#c_MySQLDiscovery__table_fzd_2yv_jz}

\*For new instances, these probes are inactive on the classifier. Discovery uses patterns for
discovery.

To use patterns, verify that the correct pattern is specified in the horizontal pattern probe on the classifier. See [Add the Horizontal Pattern probe to a classifier](https://servicenow-prod.fluidtopics.net/F1AaGd2A7GKs7d9ZAQQp5w#t_AddHorizontalPatternProbe "To use a pattern for the identification and exploration phases of horizontal discovery, you must add the Horizontal Pattern probe to the classifiers for the CIs are you trying to discover.") for instructions.

## Data collected {#c_MySQLDiscovery__section_m2g_4vq_rz}

Discovery populates these fields in the MySQL Instance \[cmdb_ci_db_mysql_instance\] table:{#c_MySQLDiscovery__table_kvf_dtk_mbb__entry__3}

| Label | Field name | Source |
|-|-|-|
| MySQL configuration | myconf | my.cnf |
| TCP port(s) | tcp_port | running_process |
| Version | version | mysqld |
[ ]

{#c_MySQLDiscovery__table_kvf_dtk_mbb}
**Related concepts**   

* [Database Administrator (DBA) report discovery](https://servicenow-prod.fluidtopics.net/eLVe8e7rIpxxjlz1~ahIgQ "Discovery and Service Mapping uses the Patterns extension sections to provide a Database Administrator report (DBA report) for the Apache Cassandra, Microsoft SQL, MySQL, MongoDB, and Oracle databases. The extension sections for each DB pattern populate the related entries tables. Discovering some of these resources may require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.")