Connecting with MySQL.NET connector

Question

I'm getting error:

Could not establish a connection to database

when I connect with MySQL .NET connector. I'm fully sure of that the username is right, the password is right, the database is right, and the server is right. Here's the code:

mysqlCon.ConnectionString = "Server=(servername);Username=(username);Pwd=(rightpassword); 
Database=(rightdatabase)";
try
{
    mysqlCon.Open();
}
catch (Exception ex)
{
    MessageBox.Show("Could not establish a connection to database!");
}

It migh tbe usefull to print the ex.Message instead of ignoring it. If you don't use the exception you caught, don't give it a name (e.g. use catch(Exception) — NKCSS
– NKCSS, Commented Apr 9, 2011 at 14:33

Damb · Accepted Answer · 2011-04-09 14:22:41Z

1

Shouldn't you use Uid instead of Username? At least connectionstrings.com says so :)
And also check what port is your MySQL running at. You might need to add port number to your connection string if you aren't using the default one - 3306.

answered Apr 9, 2011 at 14:22

Damb

14.7k6 gold badges50 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Marco · Accepted Answer · 2011-04-09 14:27:24Z

1

I use:

public MySqlConnection NewConnection(string host, int port, string db, string user, string pwd)
{
    string cstr = String.Format(
        "SERVER={0};PORT={1};DATABASE={2};UID={3};PWD={4}",
        host, port, db, user, pwdd);
    MySqlConnection conn = new MySqlConnection(cstr);
    try { conn.Open(); }
    catch (Exception ex)
    {
        conn = null;
    }
    return conn;
}

answered Apr 9, 2011 at 14:27

Marco

57.7k15 gold badges135 silver badges159 bronze badges

Comments

abatishchev · Accepted Answer · 2011-04-09 15:07:04Z

0

Make sure that the database is reachable from the machine you're running the code.

Use telnet

telnet <server> 3306

or MySQL command line client

mysql -u <user> -h <server> -P <port> -p

answered Apr 9, 2011 at 15:07

abatishchev

101k88 gold badges304 silver badges443 bronze badges

Collectives™ on Stack Overflow

Connecting with MySQL.NET connector

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related