Skip to main content

MySQL Connection

The MySQLConnection component in Robbot RPA allows you to establish a connection to a MySQL database. This component creates a session that includes the necessary information about the MySQL server, such as server address, database name, username, and password. The session can be shared with other components in your workflow, enabling seamless integration with the MySQL database.

Parameters​

Server : Insert the address or hostname of the MySQL server you want to connect to. This parameter specifies the location of the MySQL server. Type : String

Database : Insert the name of the MySQL database you want to connect to. This parameter specifies the specific database within the MySQL server Type: String

User Name : Insert the username for the MySQL database connection. This parameter provides the credentials to authenticate and access the database. Type : String

Password : Insert the password for the specified user. This parameter ensures secure authentication and authorization to the MySQL database. Type : String

Usage​

To use the MySQLConnection component in your Robbot RPA project, follow these steps:

Drag and drop the MySQLConnection component into your sequence or workflow. Configure the component by providing the necessary inputs: Insert the address or hostname of the MySQL server into the Server parameter. Insert the name of the MySQL database you want to connect to into the Database parameter. Insert the username for the MySQL database connection into the User Name parameter. Insert the password for the specified user into the Password parameter. Continue building your sequence or workflow by adding other components or actions that depend on the MySQL database connection. Execute your sequence or workflow. The MySQLConnection component will establish a connection to the specified MySQL database using the provided credentials. Use the established database connection session in subsequent components or actions to perform operations on the MySQL database, such as executing queries or retrieving data. By leveraging the MySQLConnection component, you can seamlessly connect to MySQL databases within your Robbot RPA automation, enabling efficient data access and manipulation for your business processes.