MySQL

Resources generated: A resource is generated for each table within the database. Any foreign key relationships will be detected and related records will be automatically populated. 


Functions generated: Insert, update, delete (if connecting user account has these privileges).


Officially supported versions: 5.6, 5.7, 8 


How to connect

Display Name: Give your data source a name for use within Internal. 

Host: The hostname or IP address of your data source. 

Port: Port to connect to. By default, this is prefilled with standard values: MySQL:3306. 

Username: Credentials for this data source.

Password: Credentials for this data source.

Database: The name of the database (must match). 

SSH tunneling checkbox: Check this and provide your bastion host and port if you wish to use SSH tunneling to connect.

Notes

Supports tasks (table must have an “updated_at” column).

Supports custom functions (for database).

Supports custom resources.