MySLQ Integration
To integrate MySQL to Windmill, you need to save the following elements as a resource.
| Property | Type | Description | Default | Required | Where to Find |
|---|---|---|---|---|---|
| host | string | Instance host | false | Your hosting provider's control panel or in your server's MySQL configuration file | |
| port | number | Instance port | 3306 | false | Your hosting provider's control panel or in your server's MySQL configuration file |
| user | string | Username | true | Created in MySQL (e.g., via phpMyAdmin or MySQL Workbench) or provided by your hosting | |
| database | string | Database name | true | Created in MySQL (e.g., via phpMyAdmin or MySQL Workbench) or provided by your hosting | |
| password | string | User's password | true | Created in MySQL (e.g., via phpMyAdmin or MySQL Workbench) or provided by your hosting |
MySQL as a Script Language
MySQL can be used as a script language using the MySQL driver for Deno in Typescript.
Otherwise, Python libraries and Deno are also suggesting mysql2 from npm.