Running Heidisql version 9.3.0.4984 on a Windows 7 Pro pc fully patched. The name of the pc is z210. This pc is part of a Small Business Server 2008 domain. The MySQL database is on the server.
The problem: When I try to connect to the remote MySQL , I get the error:
“Access denied for user usradminr@z210 (using password:YES)”
Here are the log in parameters I am using in Heidisql:
- Network type: MySQL (tcp/ip)
- Hostname /ip: ml350 (this is the name of the server)
Port: 3306
I enter the correct password and username. I can successfully connect to the remote MySQL using Workbench from this pc so I know MySQL is working and will accept a remote login.
What must be done to enable Heidisql to connect to the remote MySQL ?
Unable to connect to a remote server
See if adding a credential for the server you want to connect to on your Win7 pc using the Credential Manager found in the windows control panel.
Also check out this info:
http://dba.stackexchange.com/questions/66014/connect-to-sql-server-with-windows-authentication-in-a-different-domain
Also check out this info:
http://dba.stackexchange.com/questions/66014/connect-to-sql-server-with-windows-authentication-in-a-different-domain
Well, the message says it: Access denied. This means the server is accepting remote connections but rejects your user/password, or your pc name is not allowed with that user. As you said you tested Workbench from the same pc, then it can only be a wrong user/password combination.
Please login to leave a reply, or register at first.