I'm not able to connect MySQL db to Uipath studio. Please suggest a solution

[alokranjansingh20 (Alok Ranjan Singh)]

Not able to see MySQL db in the connect activity. Below are the server and port details
Server=localhost, uid=root, port=3306

[jack.chan]

@alokranjansingh20
follow these steps

2. download odbc connector (32bit!) from https://dev.mysql.com/downloads/connector/odbc/
3. install it
4. windows search- data sources
5. click this
   
6. new → mysql unicode driver
7. give credentials
8. give a name = e.g. TEST_Datasource
   
   
9. click OK

then in UiPath connect with this connection string
Dsn={dsn};uid={user};pwd={pass}
where dsn = TEST_Datasource

[alokranjansingh20 (Alok Ranjan Singh)]

Thank you for the quick response, Jack. Yes, it worked. Thanks so much, mate!!