MySQL Workbench Connection Issue

  • 8Views
  • Last Post 2 weeks ago
0
votes
Payal Rathi posted this 3 weeks ago

Hi All,

I tried to connect MySQL Workbench with Skyvia for Data Integration, but it shows foolowing error:

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

Can anyone please suggest me any solution on this?

 

Thanks,

Payal

0
votes
Simon Bubnov posted this 2 weeks ago

Looks like MySQL Workbench is installed on the same computer where MySQL database is installed. When you specify 127.0.0.1 for Server in MySQL Workbench it connects to MySQL that is installed on the same computer. The same behavior refers to Skyvia. When you specify 127.0.0.1 for Server parameter, then Skyvia try to connect to MySQL server on the same computer where Skyvia is hosted. However, there is none MySQL database on this computer and you get the error.

If you want to connect to your MySQL database, you need to specify an external IP of your computer where MySQL database is located. You can find external IP by using any site which provides such functionality. For example, https://myexternalip.com/ . You should open this URL form a computer where MySQL server is installed.

When working with MySQL connections, the main requirement is that your MySQL database must be available through the Internet. When a connection to a computer in the local network takes place, it is necessary to use port forwarding.

Please contact your system administrator to make MySQL database accessible from the Internet, at least from the Skyvia's IP address (40.118.246.204), via port forwarding. For more information, please refer to https://skyvia.com/resources/docs/index.html?mysql_connections.htm

Close