I am attempting to move a mySql db off a hosted service and host it
myself. However, I am having trouble with a remote client. The remote
client can connect to the db fine, but gets the "MySQL server has gone
away" error when the client tries to issue a query. I have checked the
causes listed in the mysql docs, but none of these seem to be
applicable. I doubt that there is a problem with the remote client, as
it was working with the previous host just fine and nothing has changed
with it.
At first I thought it was a permissions problem with either the DB or
its tables, so I temporarily gave that remote user full rights to
everything, but still got the error. I have never ran into an issue
where a remote connection attempt could connect successfully, but it
could not complete a successful query.
The old host for the db was using sql version 3.23.36 on Windows 2000,
I'm running version 3.23.49 on Debian 3.
Perhaps there is a configuration problem? Any help would be appreciated.
Curt
"Hold No Punches.." Rode brings you great shareware/freeware
programs with his honest opinions in this weekly column.
http://freepctech.com/rode
|