...
- Connect to MySQL
- Disconnect from MySQL
- Add User Access to Database
- Backup Database
- Delete Row(s) from Table
- Insert Row(s) into Table
- Remove User Access from Database
- Restore Database
- Run Query
- Select Row(s) from Table
- Export from Database
- Import into Database
Connect to MySQL
This activity connects to a MySQL Host. The Output of this activity should be used as input for all Connection parameters used for activities placed under MySQL category.
...
The Connect to MySQL activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- Database (text box editor type) (type: string): the database name to connect to, in this example "FlowsterMySQLActivities".
- Password (password editor type) (type: string): the password for the provided username. In the example from the screenshot there is used the user root with no password, which leads to a blank Password field.
- Password Binding (text box editor type) (type: string): bind to a variable containing the encrypted password for the sql server. (This parameter is used only when the user wants to send an encrypted password from outside the workflow, for example Flowster Portal).
- Port (text box editor type) (type: int32): the port number.
- Server Name (text box editor type) (type: string): the name or IP of the MySQL Server to connect to.
- Username (text box editor type) (type: string): the the username of the MySQL Server Administrator. In our example, user root is used.
...