Connection failed with MySQL .NET Connector

Question

I cannot connect to MySQL it fails on line connection.Open(), is there something wrong with my code ?

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;

namespace MySQLConnection
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

            string MyConString = "SERVER=localhost:3316;" +
                "DATABASE=mydb;" +
                "UID=user;" +
                "PASSWORD=password;";
            MySqlConnection connection = new MySqlConnection(MyConString);
            connection.Open();
            // ...
            connection.Close();

        }
    }
}

The exception will give you hints about what's wrong. What does the exception say ? — nos
– nos, Commented Apr 21, 2010 at 19:37
And what version of the Connector are you using? Recent versions use connections strings like SQL Server uses... (User ID instead of UID) — FallenAvatar
– FallenAvatar, Commented Apr 21, 2010 at 19:58

JDMX · Accepted Answer · 2010-04-21 20:27:03Z

2

this is the string format I use to connect via the MySql.Data.dll version 6.1.2.0

server={0};user id={1};password={2};database={3};port={4}

so your connection string should be

server=localhost;user id=user;password=password;database=mydb;port=3316

answered Apr 21, 2010 at 20:27

JDMX

1,50910 silver badges22 bronze badges

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

1 Comment

user310291 Over a year ago

thanks will try. I can't mark two answers as good one but I selected you as you have less points :)

Morten Mertner · Accepted Answer · 2010-04-21 20:25:49Z

2

You need to specify the Port as a separate argument in the connection string and it looks like the password key is "Pwd" instead of "Password".

See connectionstrings.com for help on the exact syntax.

answered Apr 21, 2010 at 20:25

Morten Mertner

9,4834 gold badges41 silver badges57 bronze badges

Collectives™ on Stack Overflow

Connection failed with MySQL .NET Connector

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related