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.
Cannot connect to MySQL
Post a Reply
|Oldest Newest Rating|
· 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.
· August 4, 2014
try to change system fire wall settings....
SQL & Databases
Everything SQL and Databases related in here!
|Bucky Roberts Administrator|