Create Database
Description
MySQL Server: Create Database step is used to create a new database in MySQL server.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Name of the step. This name has to be unique in a single workflow. |
| Connection | ||
| 2 | Server Name | The server name of the MySQL Server instance. This field is mandatory. |
| 3 | Port | The port number of the MySQL Server. Only variables/static values are allowed. This field is mandatory. |
| 4 | Username | A username of the MySQL Server. This field is mandatory. |
| Password | ||
| 5 | Checkbox: Accept Value as variable/static | Leave checkbox unchecked to accept Password value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for Password field to appear as Text box. |
| 6 | Password | Provide the password of the username of MySQL Server. This field is mandatory. Password is entered using a widget. The widget handles both Text (static value or environment variable) and Combo (drop down containing values from previous steps). If checkbox above is enabled, Password field appears as Text box. Else if checkbox above is disabled, Password field appears as a drop down to select fields from previous steps. |
| 7 | Test Connection (Button) | Verifies whether the connection is established or not. Note: Test Connection button does not work for previous step fields. It only works with static values and environment variables. |
| Input Fields | ||
| 1 | Step Name | The name of the step. The name must be unique in a single workflow. |
| 2 | Database Name | The name of the new database to be created. |