Re: Can't Connect to MYSQL Remotely

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Bruce P. Morin wrote:
 Hello All,

Installed a RH 8.0 server with MySQL and when we try to manage it remotely
using MySQL's control center, it can't make the connection. We get an error
back stating "Error 2013: Lost connection to MySQL Server during query."
When we try to telnet into the server using the 3306 port, it disconnects
us.

Now we have a 7.3 server running right beside it with the same exact
settings, and our firewall has 3306 open and the server's hosts.allow file
has it configured so that mysqld will be allowed.

Does anyone have any idea what could be the problem?
Look at bugzilla 75128:

http://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128

This might be the problem. Two possible workarounds are to add your clients to the /etc/hosts file of the server or add this option to your /etc/my.cnf file and restart mysqld:

[mysqld]

# fix for remote connection crashes
set-variable = thread_stack=256k

Both fixes worked for me. I don't know if this has been resolved with an up2date release by Red Hat by my guess right now is no. I've also read in past threads that the RPMs on the mysql.com site work fine.

Best Regards,
Keith
--
LPIC-2, MCSE, N+
We drive on this highway of fire
Got spam? Get spastic http://spastic.sourceforge.net



--
Psyche-list mailing list
Psyche-list@redhat.com
https://listman.redhat.com/mailman/listinfo/psyche-list

[Index of Archives]     [Fedora General Discussion]     [Red Hat General Discussion]     [Centos]     [Kernel]     [Red Hat Install]     [Red Hat Watch]     [Red Hat Development]     [Red Hat 9]     [Gimp]     [Yosemite News]

  Powered by Linux