MYSQL /etc/hosts why?

joekro · 03-04-2003, 03:56 PM

I have redhat 8 installed with mysql from the redhat CD

I need to put connecting computers names and ip address in the /etc/hosts file before that can connect to mySQL. why? Is there a way around this?

Thanks,

joe

punt · 03-04-2003, 06:49 PM

um... try allowing mysqld in your /etc/hosts.allow file

you just need a line that says:

mysqld : ALL

then restart xinetd by typing /sbin/service xinetd restart

joekro · 03-05-2003, 07:47 AM

Thanks for you response,

Tried your suggestion but Still no connection unless machine is in the hosts file. When using myODBC I receive "Lost Connection to mysql server during query.

Any other idea's ?

Joe

yellow · 03-07-2003, 03:25 AM

Found this in RedHat bug reports...

In etc/my.cnf file add following line under [mysqld] options.

set-variable=thread_stack=256k

Try connecting. Should work after the 3rd attempt.

joekro · 03-07-2003, 08:15 AM

THANK YOU, THANK YOU, THANK YOU!

Joe