Opening MySQLConnection on localhost very slow. Using .Net connector

Asked Apr 14 '16 at 23:11

Active Apr 14 '16 at 23:23

Viewed 365 times

I'm trying to learn to use C# with Visual Studio 2015 and the MySqlConnection.Open() method is taking over 15 seconds to establish the connection.

The program I've written simply establishes the connection and displays a message confirming connected or not. No queries, selection or anything else.

Does anyone know how to fix this issue. Could it be my TCP/IP settings? The port? Firewall? I'm not experienced with networking issues and I'm stumped and Google is not helping.

        try
        {
            string myConnection = "datasource=localhost;port=3306;username=root;password=root";
            MySqlConnection myConn = new MySqlConnection(myConnection);
            myConn.Open();
            MessageBox.Show("Connected");
            myConn.Close();
            MessageBox.Show("Disconnected");
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.Message);
        }

edited Apr 14 '16 at 23:23

asked Apr 14 '16 at 23:11

DMcDonald

If you were to run the above code in an empty project would it still take 15 seconds? – Tdorno Apr 14 '16 at 23:17
It is an empty project. – DMcDonald Apr 14 '16 at 23:24
I just tried it as a console application as well. Same thing happened... – DMcDonald Apr 14 '16 at 23:27
Have you tried resetting SQL server? – Tdorno Apr 14 '16 at 23:44
Yeah I've done that. Tempted to do a clean install of MySQL but not sure what thats going to achieve. – DMcDonald Apr 15 '16 at 00:12
I'd try that next... The code you've shown should not be prone to slow connectivity. – Tdorno Apr 15 '16 at 00:22
try turning off your firewall first, and check if it went faster, if it didn't, i guess it's in your port, there's a traffic in the port when you're trying to establish a connection – JC Borlagdan Apr 15 '16 at 01:56
I tried disabling the firewall, that made no difference. How can I monitor the port to detect other traffic and find another port that has no other traffic. Wireshark? – DMcDonald Apr 15 '16 at 14:24
Using MySqlConnector v 1.3.13 for Xamarin extremely slow. It's up to the developer not you. – Oct 25 '21 at 18:29

Opening MySQLConnection on localhost very slow. Using .Net connector

0 Answers0