How to connect MYSQL to uipath

Help AI Center
,
1

want to connect MYSQL to ui path
i used the expresion :“server= ;uid=;password=***;database=****”
after MYSQL server can not shown in dropdown

image
image1366×768 105 KB

2

@Shubham_Bidwai,

Try with Connection Wizard and Test Connection option to have a valid connect.

  1. First, make sure you have the UiPath.Database.Activities package installed in UiPath Studio. You can check this by going to the Manage Packages menu in UiPath Studio and searching for the package.
  2. Next, create a new workflow in UiPath Studio and add a “Connect” activity from the Database activities.
  3. In the Properties panel, configure the connection string by clicking the ellipsis button next to the ConnectionString property. In the dialog box that appears, enter the necessary details for connecting to your MySQL database, including the server name, port number, database name, and credentials.
  4. Once you have entered the connection details, click the “Test Connection” button to verify that the connection is working.
  5. If the connection is successful, you can then use other activities from the Database activities package to interact with the MySQL database, such as executing SQL queries, inserting or updating records, and so on.
3

@sarathi125 i can not understand
where is test connection button after fill the detailes in property pannel

4

@Shubham_Bidwai,

Check as shown here

image
image1366×656 65.2 KB

5

Search! Did you try it? :frowning: