Specify password in mysql connection string

Question

from C# program i have connect to mysql database how to specify a password with a single quote character, for get next error

Format of the initialization string does not conform to specification
starting at index

for this connection string

Server = srv; Database = db; User Id = user; Password = 'ktrnhjyyst;

Thanks

Alex K. · Accepted Answer · 2014-04-25 10:59:20Z

2

You need to quote tokens that contain restricted chars:

var cn = "Server=srv;Database=db;User Id=user;Password=\"'ktrnhjyyst;\"";

answered Apr 25, 2014 at 10:59

Alex K.

177k32 gold badges276 silver badges299 bronze badges

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

1 Answer 1