C# .Net MysqlConnector ConnectionString Password Problem / Issue

Question

need help with some stupid password problems. Following problem:

Cannot connect to mysql server with some passwords ^^

If i use a password with the same "connection string" details, for example:

The following Passwords are exactly in the MySql Server (quotes, double-quotes, semicolon);

"pwd=123456"; // works

"pwd=123456;"; // works

";pwd=123;456;' // System.ArgumentException

";pwd=123;456;'" // System.ArgumentException

//Connection String Variant 1:

string connString = string.Format("server={0};port={1};uid={2};pwd={3};database={4};sslmode=preferred",
                tbDbServername.Text.ToLower(),
                (uint)Convert.ToInt32(tbDbServerPort.Text),
                tbDbServerUsername.Text.ToLower(),
                tbDbServerPassword.Password,
                tbDbServerDatabase.Text.ToLower()
                );

//Connection String Variant 2:

string connString = string.Format("server={0};port={1};uid={2};pwd='{3}';database={4};sslmode=preferred",
                tbDbServername.Text.ToLower(),
                (uint)Convert.ToInt32(tbDbServerPort.Text),
                tbDbServerUsername.Text.ToLower(),
                tbDbServerPassword.Password,
                tbDbServerDatabase.Text.ToLower()
                );

I know it's stupid. Why should someone use a password with connection string details....but would be nice to solve this.

Greetings from Germany :)

madreflection · Accepted Answer · 2020-02-21 22:05:38Z

6

Use a MySqlConnectionStringBuilder to construct your connection string. It will do any escaping/quoting that's needed.

In your case, you would want to do this:

MySqlConnectionStringBuilder builder = new MySqlConnectionStringBuilder()
{
    Server = tbDbServername.Text.ToLower(),
    Port = (uint)System.Convert.ToInt32(tbDbServerPort.Text),
    UserID = tbDbServerUsername.Text.ToLower(),
    Password = tbDbServerPassword.Password,
    Database = tbDbServerDatabase.Text.ToLower(),
    SslMode = MySqlSslMode.Preferred
};

string connString = builder.ConnectionString;

answered Feb 21, 2020 at 22:05

madreflection

5,0273 gold badges26 silver badges34 bronze badges

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

2 Comments

Thomas Over a year ago

Too easy. Thank you very much. Works :)

madreflection Over a year ago

Glad to be of assistance.

MKR · Accepted Answer · 2020-02-22 07:07:10Z

1

Certain characters are not allowed in connection string like [] {}() , ; ? * ! @ =. without using escape-character. The use of ; as part of password has caused problem as its expected to be used as delimiter

The special notes on special characters is mentioned at relatively odd place in Microsoft documentation:

Notes on special character

If used in an OLE DB or ODBC connection string, a login or password must not contain the following characters: [] {}() , ; ? * ! @ =. These characters are used to either initialize a connection or separate connection values.

ConnectionString

The basic format of a connection string includes a series of keyword/value pairs separated by semicolons. The equal sign (=) connects each keyword and its value. To include values that contain a semicolon, single-quote character, or double-quote character, the value must be enclosed in double quotation marks. If the value contains both a semicolon and a double-quote character, the value can be enclosed in single quotation marks. The single quotation mark is also useful if the value starts with a double-quote character. Conversely, the double quotation mark can be used if the value starts with a single quotation mark. If the value contains both single-quote and double-quote characters, the quotation mark character used to enclose the value must be doubled every time it occurs within the value.

edited Feb 22, 2020 at 7:07

answered Feb 21, 2020 at 22:20

MKR

20.2k4 gold badges26 silver badges36 bronze badges

6 Comments

MKR Over a year ago

@Thomas A worth reading for connection string formatr MySQL at dev.mysql.com/doc/refman/8.0/en/…. Please note that when we connect from C# assembly then it connects via MySQL/ODBC connector.

Bradley Grainger Over a year ago

All those characters can be used in MySQL user passwords, and can be used in a MySQL connection string if escaped properly (use MySqlConnectionStringBuilder to do this).

MKR Over a year ago

@bradleyGraingrr I agree it can be used with proper escape character and it's mention in link with my answer too. I don't understand why confusion came?

Bradley Grainger Over a year ago

Your answer states in its first sentence: "Certain characters are not allowed in connection string like [] {}() , ; ? * ! @ =.". This is not true for MySQL, which is what the question is about.

MKR Over a year ago

@BradleyGrainger I meant without escape character or other formats. I over looked as it was mentioned in link. Moreover the second link for specifically MySQL it's states that for MySQL connection string can URI-like connection strings or key-value pairs. But point is when connection string is used via MySQL/ODBC connectors those characters are not allowed without escape-characters.

|

Collectives™ on Stack Overflow

C# .Net MysqlConnector ConnectionString Password Problem / Issue

2 Answers 2

2 Comments

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related