Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Universal DiscoveryContent Pack 26.00 (CP26)

Use > Discovery Modules > Database > MySQL Discovery > How to Discover MySQL Databases by Shell

How to Discover MySQL Databases by Shell

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

Prerequisites - Set up protocol credentials
This discovery uses the following protocols:
- SSH Protocol
- Telnet Protocol
- NTCMD Protocol
For credential information, see Supported Protocols.
Prerequisites - Retrieve information
To retrieve all relevant information, DFM must have read permissions for the $MYSQL_HOME directory and for executing mysqld (mysqld.exe or mysqld-nt.exe for Windows) with the following parameters:
```
mysqld --verbose --help
```
```
mysqld --version
```
If the my.cnf (my.ini) file is located outside the $MYSQL_HOME directory, you must add permissions for reading to it.
Run the discovery
1. Run the Range IPs by ICMP job to discover which of the machines in the IP range are up and running.
2. Run the Host Connection by Shell job to create Shell CITs.
3. Run any of host resources jobs to gather information about processes running on the host.
4. Run the MySQL by Shell job to discover information about MySQL configuration and replication.