MySQL
Set up a MySQL connection in the workspace for the database actions to use.
MySQL
Connects a MySQL database to the workspace. The MySQL database actions in your robots use this connection.
Fields
Connection string
Enter the full connection string for the MySQL database. It follows this shape:
mysql://user:password@host:port/database
Example:
mysql://admin:mypassword@192.168.0.1:3306/production
| Part | What it is |
|---|---|
user | The database user's name |
password | That user's password |
host | The server's IP address or name |
port | The connection port (default: 3306) |
database | The database's name |
tip
The connection string usually comes from the database administrator, or from the MySQL server's own settings.
Using it in the Designer
For a robot to use this connection, add the MySQL - Connection action to the flow. In the action's settings, pick the connection saved in the workspace. Later MySQL actions (query, insert, update and the rest) use it automatically.