Cannot connect to MySQL

+1 daniel julian · July 30, 2014
I was able to connect to mySQL through my local machine. However, I have placed the server on a remote machine and when I try to connect to it, I get the following error:

Lost connection to MySQL server at 'reading initial communication packet', system error: 0

Im using SQL workbench to connect. I use the remote machine's actual name for the hostname and using port 139. I have MySQL started up as a service on the remote machine as well. When googling the error I get lots of jazz about editing a file in /etc/hosts.allow and my.cnf and whatnot. However, these locations were specified for linux machines. I have a windows 7 machine for both and therefore do not have these locations.

Any help would be greatly appreciated.

Post a Reply

Replies

Oldest  Newest  Rating
0 JOhaL jaTT · August 4, 2014
try to change system fire wall settings....
0 daniel julian · July 31, 2014
Figured it out. 'root' was pointing to the root of the local machine and the root user on the remote machine was pointing to itself. So I had it connect to an admin user and it connected fine with no errors.
  • 1

SQL & Databases

107,064 followers
About

Everything SQL and Databases related in here!

Links
Moderators
Bucky Roberts Administrator