MySQL Bugs: #65717: MySQL .NET connector only tries to connect to the local-host

Bug #65717	MySQL .NET connector only tries to connect to the local-host
Submitted:	23 Jun 2012 20:10	Modified:	25 Jun 2012 8:11
Reporter:	Naim Abda	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S1 (Critical)
Version:	6.5.4	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
MySQL's .NET Client ignores the "Server" variable from the connection string and only tries to connect to the local computer.

Snapshot from VS 2010 attached.

How to repeat:
In MS Visual-Studio 2010: Open the "Server Explorer",
Right-click "Data Connections",
Click "Add Connection...",
Select "MySQL Database" and click "Continue".

In "Server Name" type any address except the local computer, and server login info.

Click "Test Connection" and get a error.

Error Message: "Access Denied for user 'root'@'<local-PC-name>' (Using Password: Yes)"

Suggested fix:
Check out the MySQL .NET source code for any un-removed testing codes.

Can you try to execute:

select user, host from mysql.user;

on your MySQL server using mysql command line or any other client, and attach results to this report? As private file or comment, if you prefer...