mysql in skyvia by dev art

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
ll2016
Posts: 11
Joined: Tue 31 May 2016 06:12

mysql in skyvia by dev art

Post by 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

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

Re: mysql in skyvia by dev art

Post by 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.

ll2016
Posts: 11
Joined: Tue 31 May 2016 06:12

Re: mysql in skyvia by dev art

Post by 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.

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

Re: mysql in skyvia by dev art

Post by alexa » Thu 09 Jun 2016 07:07

We recommend you to see the following http://dev.mysql.com/doc/refman/5.6/en/ ... erver.html

ll2016
Posts: 11
Joined: Tue 31 May 2016 06:12

Re: mysql in skyvia by dev art

Post by 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:)

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

Re: mysql in skyvia by dev art

Post by alexa » Thu 09 Jun 2016 08:03

Thank you for updating us on this issue.

Please let us know if any questions arise.

Post Reply