-
-
新错误。。。System.Data.SqlClient.SqlException:“用户 'Mylink' 登录失败。”
“MySQL.exe”(CLR v4.0.30319: DefaultDomain): 已加载“C:\WINDOWS\Microsoft.Net\assembly\GAC_32\mscorlib\v4.0_4.0.0.0__b77a5c561934e089\mscorlib.dll”。已加载符号。
“MySQL.exe”(CLR v4.0.30319: DefaultDomain): 已加载“E:\Desktop\SelfStudy\unity\SocketServer\MySQL\bin\Debug\MySQL.exe”。已加载符号。
“MySQL.exe”(CLR v4.0.30319: MySQL.exe): 已加载“C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll”。已加载符号。
“MySQL.exe”(CLR v4.0.30319: MySQL.exe): 已加载“C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll”。已加载符号。
“MySQL.exe”(CLR v4.0.30319: MySQL.exe): 已加载“C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll”。已加载符号。
“MySQL.exe”(CLR v4.0.30319: MySQL.exe): 已加载“C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Data.resources\v4.0_4.0.0.0_zh-Hans_b77a5c561934e089\System.Data.resources.dll”。模块已生成，不包含符号。
“MySQL.exe”(CLR v4.0.30319: MySQL.exe): 已加载“C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Configuration\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Configuration.dll”。已加载符号。
“MySQL.exe”(CLR v4.0.30319: MySQL.exe): 已加载“C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll”。已加载符号。
“MySQL.exe”(CLR v4.0.30319: MySQL.exe): 已加载“C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.Transactions\v4.0_4.0.0.0__b77a5c561934e089\System.Transactions.dll”。已加载符号。
“MySQL.exe”(CLR v4.0.30319: MySQL.exe): 已加载“C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.dll”。已加载符号。
“MySQL.exe”(CLR v4.0.30319: MySQL.exe): 已加载“C:\WINDOWS\Microsoft.Net\assembly\GAC_32\System.EnterpriseServices\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.EnterpriseServices.Wrapper.dll”。已加载符号。
引发的异常:“System.Data.SqlClient.SqlException”(位于 System.Data.dll 中)
引发的异常:“System.Data.SqlClient.SqlException”(位于 System.Data.dll 中)
引发的异常:“System.Data.SqlClient.SqlException”(位于 System.Data.dll 中)
引发的异常:“System.Data.SqlClient.SqlException”(位于 System.Data.dll 中)
“MySQL.exe”(CLR v4.0.30319: MySQL.exe): 已加载“C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\mscorlib.resources\v4.0_4.0.0.0_zh-Hans_b77a5c561934e089\mscorlib.resources.dll”。模块已生成，不包含符号。
引发的异常:“System.Data.SqlClient.SqlException”(位于 System.Data.dll 中)
引发的异常:“System.Data.SqlClient.SqlException”(位于 System.Data.dll 中)
引发的异常:“System.Data.SqlClient.SqlException”(位于 System.Data.dll 中)
“MySQL.exe”(CLR v4.0.30319: MySQL.exe): 已加载“C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\System.Transactions.resources\v4.0_4.0.0.0_zh-Hans_b77a5c561934e089\System.Transactions.resources.dll”。模块已生成，不包含符号。
System.Transactions Critical: 0 : <TraceRecord xmlns="http://schemas.microsoft.com/2004/10/E2ETraceEvent/TraceRecord" Severity="Critical"><TraceIdentifier>http://msdn.microsoft.com/TraceCodes/System/ActivityTracing/2004/07/Reliability/Exception/Unhandled</TraceIdentifier><Description>未处理的异常</Description><AppDomain>MySQL.exe</AppDomain><Exception><ExceptionType>System.Data.SqlClient.SqlException, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType><Message>用户 'Mylink' 登录失败。</Message><StackTrace> 在 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
在 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
在 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
在 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
在 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
在 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal&amp; connection)
在 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal&amp; connection)
在 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&amp; connection)
在 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
在 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
在 System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
在 System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
在 System.Data.SqlClient.SqlConnection.Open()
在 MySQL.Program.Main(String[] args) 位置 E:\Desktop\SelfStudy\unity\SocketServer\MySQL\Program.cs:行号 22</StackTrace><ExceptionString>System.Data.SqlClient.SqlException (0x80131904): 用户 'Mylink' 登录失败。
在 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling)
在 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
在 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
在 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
在 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
在 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal&amp; connection)
在 System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal&amp; connection)
在 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal&amp; connection)
在 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
在 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
在 System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
在 System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry)
在 System.Data.SqlClient.SqlConnection.Open()
在 MySQL.Program.Main(String[] args) 位置 E:\Desktop\SelfStudy\unity\SocketServer\MySQL\Program.cs:行号 22
ClientConnectionId:91ce2609-d577-4bc7-9494-e87192a4a836
Error Number:18456,State:1,Class:14</ExceptionString><DataItems><Data><Key>HelpLink.ProdName</Key><Value>Microsoft SQL Server</Value></Data><Data><Key>HelpLink.EvtSrc</Key><Value>MSSQLServer</Value></Data><Data><Key>HelpLink.EvtID</Key><Value>18456</Value></Data><Data><Key>HelpLink.BaseHelpUrl</Key><Value>http://go.microsoft.com/fwlink</Value></Data><Data><Key>HelpLink.LinkId</Key><Value>20476</Value></Data></DataItems></Exception></TraceRecord>
“System.Data.SqlClient.SqlException”类型的未经处理的异常在 System.Data.dll 中发生
用户 'Mylink' 登录失败。“MySQL.exe”(CLR v4.0.30319: MySQL.exe): 已加载“C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\Common7\IDE\PrivateAssemblies\Runtime\Microsoft.VisualStudio.Debugger.Runtime.dll”。
程序“[14620] MySQL.exe”已退出，返回值为 -1073741510 (0xc000013a)。
Unity - A计划（一年有效期）
![]()
扫二维码继续学习 二维码时效为半小时
mySQL数据库问题
13
回复 1194
浏览
回复 1194
浏览
class Program
{
static void Main(string[] args)
{
string connectionStr = "Persist Security Info=False;database=junglewar;Data source=127.0.0.1;user id=root;Password=z125647890";
string connectionStr2 = "server=(local);database=junglewar;user id=root;password=z125647890;";
SqlConnection connection = new SqlConnection(connectionStr);
//Console.WriteLine(connection.State);
connection.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM city where ID=1;", connection);
Console.WriteLine(connection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string userid = reader[0].ToString();
string password = reader[1].ToString();
Console.WriteLine(userid + ";" + password + "\n");
}
reader.Close();
connection.Close();
Console.ReadKey();
}
}
版本：vs2017 mySQL5.7
输出：引发的异常:“System.Data.SqlClient.SqlException”(位于 System.Data.dll 中)
错误：1.System.Data.SqlClient.SqlException:“在与 SQL Server 建立连接时出现与网络相关的或特定于实例的错误。未找到或无法访问服务器。请验证实例名称是否正确并且 SQL Server 已配置为允许远程连接。 (provider: Named Pipes Provider, error: 40 - 无法打开到 SQL Server 的连接)”
2.如果在ConnectionStr语句中加上port，就会出现如下错误：System.ArgumentException:“不支持关键字: “port”。”
然而database和账号密码多次核对，并没有错误。
所有回复
-
关于第一个错误可以看下
http://www.jb51.net/article/59352.htm
第二个问题，可以尝试下
用逗号，比如 localhost,8888
(0) 回复 (2) -
-
-
-
-
-
-
-
重新装了一遍mySQL 依旧连接失败。。。。。
错误还是用户root连接失败。。。
