LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 03-04-2003, 04:56 PM   #1
joekro
LQ Newbie
 
Registered: Mar 2003
Posts: 3

Rep: Reputation: 0
Question MYSQL /etc/hosts why?


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
 
Old 03-04-2003, 07:49 PM   #2
punt
Member
 
Registered: Jun 2001
Distribution: Fedora 22
Posts: 371

Rep: Reputation: 30
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
 
Old 03-05-2003, 08:47 AM   #3
joekro
LQ Newbie
 
Registered: Mar 2003
Posts: 3

Original Poster
Rep: Reputation: 0
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
 
Old 03-07-2003, 04:25 AM   #4
yellow
LQ Newbie
 
Registered: Mar 2003
Location: South Africa
Distribution: Redhat
Posts: 1

Rep: Reputation: 0
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.

Last edited by yellow; 03-07-2003 at 04:44 AM.
 
Old 03-07-2003, 09:15 AM   #5
joekro
LQ Newbie
 
Registered: Mar 2003
Posts: 3

Original Poster
Rep: Reputation: 0
THANK YOU, THANK YOU, THANK YOU!

Joe

 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
External Hosts Resolve but Local Hosts Do Not kjm9 Linux - Networking 7 11-19-2005 04:51 PM
hosts.allow & hosts.deny question... jonc Linux - Security 9 03-05-2005 10:41 PM
Adding shell commands to hosts.deny and hosts.allow ridertech Linux - Security 3 12-29-2003 04:52 PM
hosts.deny and hosts.allow defaults? gui10 Linux - Security 5 12-20-2001 02:57 AM


All times are GMT -5. The time now is 08:44 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration