Connections

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.