c# - MysqlConnector special character in string connection

Question

I use MySqlConnector to make a connection to a database. When constructing my connection string the user has a password which contains a special character ("€") and his password is "€ test". The fact that this character is passed to the connection string returns the "acces deined" error. Do you know what to do to allow the connection with this type of character in the password?

 string connStr = server=127.0.0.1;user=test;database=EXPERT_alpha;port=3306;password='€test'; convert zero datetime=True;Pooling=False;

mySQlCnx = new MySqlConnection(connStr); mySQlCnx.Open();

question from:https://stackoverflow.com/questions/65842812/mysqlconnector-special-character-in-string-connection

Answer 1

How about using € instead of €?

 string connStr = server=127.0.0.1;user=test;database=EXPERT_alpha;port=3306;password='€test'; convert zero datetime=True;Pooling=False;