...
The Add User Access to Database activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- Host Name (value selector list) (type: string): the hostname that the user can connect from. In this case localhost will be used, so that the user can connect to MySQL Admin from the same machine where the server is installed.
- Username for Access (text box editor type) (type: string): the name of the user that will receive permissions.
As mentioned above, the values for all the required parameters can be provided by IN arguments or variables. Below is an example of predefined arguments, ready to be used by the Add User Access to Database activity:
...
The Read Only Output variable are the possible output values that the activity will provide:
- Output (type: boolean): outputs True or False if the execution was successful or not.
Execution: the activity will search if the user already exists in the user table from the mysql database (MySQL system database). If found, it will grant access to the database where the activity is connected:
Backup Database
This activity creates an .sql file backup for the selected database.
...