Connect to MySQL on phpMyadmin

Discuss RoboTask here
Post Reply
torbrjp
Posts: 2
Joined: Thu Sep 05, 2019 3:44 pm

Connect to MySQL on phpMyadmin

Post by torbrjp »

Hello,

I want to execute a RoboTask SQL Query on a MySQL server that is in phpMyadmin. How can I connect to the MySQL server using either the Data Link File or Connection String?
Oleg
Site Admin
Posts: 3000
Joined: Thu Jan 01, 1970 1:00 am
Contact:

Re: Connect to MySQL on phpMyadmin

Post by Oleg »

Just install MySQL ODBC connector for windows 32-bit
Next - configure user or system DSN in ODBC data source administrator Now you can execute SQL expressions directly from RoboTask on MySQL database.

Please note that RoboTask is 32-bit application. So it uses 32-bit ODBC DSN.
you can find ODBC data source administrator 32-bit here: C:\Windows\SysWOW64\odbcad32.exe
Oleg Yershov
Oleg
Site Admin
Posts: 3000
Joined: Thu Jan 01, 1970 1:00 am
Contact:

Re: Connect to MySQL on phpMyadmin

Post by Oleg »

Also look here how you can create the connection string: https://robotask.com/forum/viewtopic.ph ... 4832#p4832
Oleg Yershov
Post Reply