Mysql in visual studio for VB.NET

Question

0.00/5 (No votes)

See more:

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 4-Jul-20 15:27pm

Cody O'Meara

Updated 6-Jul-20 0:15am

Add a Solution

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

DerekT-P · Answer 1 · 2020-07-06T00:15:00

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