Re: Can't connect to MySQL server remotely

[Shawn Green]

That "version and gibberish" is the server saying "hi" to what it expect to be a client. That's good as you should be able to perform the login process using an actual client.

There are 3 primary things to check:

* Does your local operating system allow mysql (the program) to access the network (which would include the internet)

* Did you validate that your local firewall is disabled or tuned to permit mysql to pass through?

* Did you validate that your remote firewall (where your server is) is disabled or open? (probably so or the telnet test would not have worked and you could not see port 3306 from any other computer in the world. Please note: this is not an inherently safe situation as ANYONE has the opportunity to attempt to login to your database server)

As we have pretty much verified that your server is most likely wide open for access, focus on your more local network access restrictions. Something outside the server's host machine is blocking your network connection. This is not a privileges failure as the client handshake has not made it that far, yet, in the process.
--
Shawn Green
MySQL Senior Principal Technical Support Engineer