MySQL
MySQL is a widely-used open-source relational database management system (RDBMS) that stores and manages structured data using SQL (Structured Query Language). As one of the most popular database platforms globally, MySQL powers countless applications, websites, and enterprise systems, providing reliable, scalable data storage and retrieval capabilities.
| Category | Database |
| Direction | Query source |
| Sign-in | None |
| Query languages | STIX, MySQL |
| Query templates | 1 |
| Website | mysql.com |
Before you start
The setup page can't take credentials for MySQL yet. Create the connection, then contact Huntbase support to finish signing it in.
For the vendor's own instructions, see MySQL GRANT documentation.
Connect MySQL
- Go to Connections and click New connection, or click New connection on the MySQL product page.
- On Product, pick MySQL and choose the Owner.
- On Details, give the connection a Name and, optionally, a Description.
- On Connect, fill in the settings and credentials described below.
- On Verify, review the summary and click Create & check.
For everything else on the setup page — saving a draft, I'll do this later, and what each check result means — see Connections.
Settings
Where your MySQL lives:
| Field | Required | Notes |
|---|---|---|
| Server Address | Yes | Specify the IP address or hostname of the data source. |
| Port | Yes | Set the port number that is associated with the hostname or IP address. Defaults to 3306. |
| Database | Yes | The name of the database that holds the table. |
| Self-Signed Cert (PEM) | No |
Advanced settings
These settings are under Advanced. You can usually leave them alone.
| Field | Required | Notes |
|---|---|---|
| Connection certificate | No | Self-signed SSL certificate and CA content (root and intermediate) of the data source. |
| Table | Yes | The name of the single table to query. |
Query it
Once connected, MySQL can serve these languages in a query tab, and Scout can use it when you ask in Auto:
| Language | Use it for |
|---|---|
| STIX | STIX patterns for indicator sweeps, translated into the product's native search. |
| MySQL | Native MySQL, sent as written. |
Example: MySQL
Recent authentication log entries for a user — Raw SQL passthrough to retrieve recent auth_log rows for a user.
SELECT * FROM auth_log WHERE user = '{{username}}' LIMIT 100
MySQL ships with 1 query template. Find them in Library › Queries — see Query templates.
Next steps
- Connections — health, credentials and settings after you connect
- Query languages — syntax, parameters and time ranges
- Chatting with Scout — ask questions without writing a query
- All integrations — the rest of the catalog