Connect to remote MySQL without ODBC

[ui_auto]

Hello, I need UiPath to connect to a remote MySQL database. However would like to avoid installing any external dependency in the machine as this needs to be running unattended and would like to be self sufficient.

All the documented solutions talk about installing a driver and ODBC connector and connecting using a DSN. Is there a way I can avoid all of this?

[fernando_zuluaga]

Hi @ui_auto

can you give a try with the following method?

Is it possible to connect to mysql database using uipath? If yes? How to connect to MySQL Database?

Hello, fr MySql connection, inside Connect node you can simply pass the connection string is enough. It will automatically gets updated “server=‘10.100.X.XX’; UID=‘UiPath’; PASSWORD=‘******’; DATABASE=‘UiPath’; PORT=‘3306’;” for example i have attached a smple flow, edit it accordingly to your db server.MySQL_Test.xaml (5.6 KB) Thanks, Meg

You can create your own connection with the following examples

MySQL connection strings - ConnectionStrings.com

Regards!
Regards!

[Sree_Krishnan_vellinezhi]

@fernando_zuluaga

MySQL connection strings - ConnectionStrings.com

hi @fernando_zuluaga

For me its showing the below error

[piyush_jain2 (Piyush Jain)]

@Sree_Krishnan_vellinezhi have you got any fix for the error. I am getting same.