开发者

What is wrong with this mysql connection string?

开发者 https://www.devze.com 2023-01-07 14:31 出处:网络
I am using this connection string, <add name=\"connectionString\" connectionString=\"server=10.1.1.16;user id=root;

I am using this connection string,

<add name="connectionString" connectionString="server=10.1.1.16;user id=root;
password=lmslive; database=lmslive; pooling=false;" 
      providerName="MySql.Data.MySqlClient"/>

and this database lmslive is in a system next to mine connected via proxy.... And i executed this query on that system,

  GRANT ALL PRIVILEGES ON lmslive.* T开发者_高级运维O 'lmslive'@'10.1.1.15'
    IDENTIFIED BY 'lmslive' WITH GRANT OPTION;

I get the error,

Access denied for user 'root'@'XAVY-PANDIYA' (using password: YES).. Any suggestion? what am i missing?


Replace user id=root with user id=lmslive in your connectionString.

0

精彩评论

暂无评论...
验证码 换一张
取 消