distal-attribute
distal-attribute
distal-attribute
distal-attribute

Connecting to MySQL on another windows machine

User, date Message
Written by noa.drach
9 months ago
Category: General
2 posts since Thu, 14 Nov 13
I saw several threads related to connecting to a remote sql instance and it looks like they are all related to OS other than windows - so i decided to post this question.

I'm using a W7 64bit machine and i try to connect to mysql that is installed on a Windows Server 2008 r2 machine - I use the TCP\IP connection option

and i keep getting the error message

SQL Error (1045) in statement #0: Access denied for user '<existing user>'@'<my ip>'

any ideas on what I should check?
Written by ansgar
9 months ago
4955 posts since Fri, 07 Apr 06
See the myriad of search results on that error message in Google.

Just some hints:
* This is totally unrelated to your OS, or the OS on which the server runs
* "Access denied" is mostly a privilege error. Your username in conjunction with the ip is not allowed to connect there.
* If you're sure the username exists on that server, watch out for the hostname configured in the account, and if that matches your client ip.
Written by noa.drach
9 months ago
2 posts since Thu, 14 Nov 13
Got it (I think - the remote machine belongs to someone else and i need to wait for them to set the user so i can login).

The reason i posted this is because I saw several issues where SSH was discussed in relation to this error - so it through me off-track.

Thanks
 

Please login to leave a reply, or register at first.