What is wrong with this mysql connection string?

Question

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.* TO '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?

Asaph · Accepted Answer · 2010-07-15 06:22:43Z

3

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

answered Jul 15, 2010 at 6:22

Asaph

163k25 gold badges204 silver badges204 bronze badges

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

4 Comments

ACP Over a year ago

@asaph when i give that

Unable to retrieve stored procedure metadata.  Either grant  SELECTprivilege to mysql.proc for this user or use "use procedure bodies=false" with  your connection string.

Rippo Over a year ago

It sounds like your perms are a bit messed up.

Asaph Over a year ago

@Pandiya Chendur: The error message is telling you exactly what to do next. You have 2 choices: 1) Run a statement like GRANT SELECT ON mysql.proc TO 'lmslive'@'10.1.1.15' IDENTIFIED BY 'lmslive'. or 2) Set the use procedure bodies=false option.

Asaph Over a year ago

@Pandiya Chendur: Glad to hear that. Please mark this answer as correct :)

Collectives™ on Stack Overflow

What is wrong with this mysql connection string?

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related