无法使用c＃连接到Mysql数据库 [英] Cannot connect to Mysql database using c#

问题描述

我正在尝试通过c＃web服务连接到Mysql数据库

数据库的密码是 a~Sz4x; 1）X（N 上面的密码中有; （SPECIAL CHARACTER），它是c＃中的行终止符，它会抛出以下错误

初始化字符串的格式不符合从索引70开始的规范。

任何帮助都将受到赞赏。

解决方案

使用此：

  string  connString =  @  SERVER = example.com; DATABASE = db_beta; UID = db_demo; PASSWORD = a~Sz4x; 1）X（N;; 

如需了解更多信息，请参阅： 2.4.4.5字符串文字 [ ^ ]

试试这个：

  string  connString =  @  SERVER = example.com; DATABASE = db_beta; UID ='db_demo'; PASSWORD ='a~Sz4x; 1）X（N'; ; 

或者这个：

  string  connString =   SERVER = example.com +  ; + 
   DATABASE = db_beta; + 
  < span class =code-string> UID ='db_demo'; + 
   PASSWORD = 'A〜Sz4x; 1）X（N';; 

I am trying to connect to an Mysql database through c# web service
The password for the database is a~Sz4x;1)X(N The above password has ;(SPECIAL CHARACTER) in it which is a line terminator in c# it throws below error

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

Any help will be appreciated.

解决方案

Use this:

string connString = @"SERVER=example.com;DATABASE=db_beta;UID=db_demo;PASSWORD=a~Sz4x;1)X(N;";

For further information, please see: 2.4.4.5 String literals[^]

Try this :

string connString = @"SERVER=example.com;DATABASE=db_beta;UID='db_demo';PASSWORD='a~Sz4x;1)X(N';";

or this:

string connString = "SERVER=example.com" + ";" +
"DATABASE=db_beta;" +
"UID='db_demo';" +
"PASSWORD='a~Sz4x;1)X(N';";

这篇关于无法使用c＃连接到Mysql数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！