mysql in skyvia by dev art

[ll2016]

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]

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]

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]

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

[ll2016]

thank you Alex, finally we managed to solve it. Grant all permission and seems to be working now...
thank you devart team:)

[alexa]

Thank you for updating us on this issue.

Please let us know if any questions arise.