mysql in skyvia by dev art

mysql in skyvia by dev art

Postby ll2016 » Wed 08 Jun 2016 23:39

HI

Hopefully iam at the right column but iam having difficulty connecting to my mysql local host that i just installed on my laptop. Iam trying to connect via skyvia to set mysql as a target destination and fill up all the properties as required:

Name:mysql57
server: try with localhost and 127.0.0.1
port 3306
user id: root
password: XXXX
database: test

and keep getting error message "Can't connect to MySQL server on '127.0.0.1' (10061):
No connection could be made because the target machine actively refused it 127.0.0.1:3306"

anyone able to help? thank you in advance
ll2016
 
Posts: 11
Joined: Tue 31 May 2016 06:12

Re: mysql in skyvia by dev art

Postby alexa » Thu 09 Jun 2016 05:58

In case you want to connect to the MySQL server from another PC, you have to use an external IP address of the machine with the MySQL server rather than 'localhost' or '127.0.0.1'.

Also, we recommend you to check that the port is correct, the MySQL server is running and available from another PCs.
alexa
Devart Team
 
Posts: 1963
Joined: Fri 24 Jun 2011 14:17

Re: mysql in skyvia by dev art

Postby ll2016 » Thu 09 Jun 2016 06:11

Hi Alex,

Thank you. As for now, Iam just trying to connect from skyvia website to my laptop in which mysql was installed, hence localhost is fine right?

yeah the port is correct when i look it up from the mysql workbench and it is running. I could access the database from mysql workbench locally. It is only on the skyvia website iam having trouble because I want to connect my mailchimp database as source to mysql as target. The source connection is fine. the target connection is where i couldn't set it up.
ll2016
 
Posts: 11
Joined: Tue 31 May 2016 06:12

Re: mysql in skyvia by dev art

Postby alexa » Thu 09 Jun 2016 07:07

alexa
Devart Team
 
Posts: 1963
Joined: Fri 24 Jun 2011 14:17

Re: mysql in skyvia by dev art

Postby ll2016 » Thu 09 Jun 2016 07:25

thank you Alex, finally we managed to solve it. Grant all permission and seems to be working now...
thank you devart team:)
ll2016
 
Posts: 11
Joined: Tue 31 May 2016 06:12

Re: mysql in skyvia by dev art

Postby alexa » Thu 09 Jun 2016 08:03

Thank you for updating us on this issue.

Please let us know if any questions arise.
alexa
Devart Team
 
Posts: 1963
Joined: Fri 24 Jun 2011 14:17


Return to dotConnect for MySQL