What is wrong with this mysql connection string?
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
.
精彩评论