Click here to Skip to main content
15,877,859 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I installed the MySQL package to allow MySQL connections in visual studio. As I am going in to enter the Mysql server related info just like I would in WinSCP or putty I get the following connection when clicking "Test Connection"

---------------------------
Microsoft Visual Studio
---------------------------
Reading from the stream has failed.

Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond


---------------------------
OK   
---------------------------


When I click the dropdown for the Database name I get an error unable to retrieve the list of the databases.

Info I put in:
Server 45.32.X.XXX
user root
pass ***********
port 22


Everything is correct as I can successfully log in to PHPMyAdmin and WinSCP.= with same port, server, user, pass.

What I have tried:

Not sure what else I can try... It works when I connect otherways but I want the ability to create vb.net software so there is desktop software along with website software.
Posted
Updated 6-Jul-20 0:15am
Comments
Richard MacCutchan 5-Jul-20 3:31am    
The message suggests that the MySQL server instance is not responding. But it is impossible to guess why that should be so. Check any server logs to see if they give some clues.
Andre Oosthuizen 6-Jul-20 4:28am    
Also try to change your port to 8080, normally the culprit.

1 solution

By default, MySql uses port 3306, not port 22 (which is normally an FTP port). Correct the port number and try again.
If still failing, check that your MySql server allows remote connections. If you can connect OK via phpMyAdmin, it may be that phpMyAdmin is running on the same server, so not a remote connection. Also check that user root is authorised from any IP address, not just local addresses. (Use phpMyAdmin to verify that)
If remote connections are allowed, check your own firewall - maybe you're blocking the port. As above, I'd normally expect to be connecting to mySql on 3306, not 22!

(Not sure what WinSCP has to do with it - I thought that was an FTP tool?)

Seems like you may be confusing an FTP connection with MySql...
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900