Connecting to MySQL on another windows machine

noa.drach posted 4 years ago in General
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?
ansgar posted 4 years ago
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.
noa.drach posted 4 years ago
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.


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