RE: MySQL only listens on localhost

2007-10-14 Thread Franz Edler
Thanks to all:
 
 Check for bind-address in your my.cnf file

That solved the problem.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



MySQL only listens on localhost

2007-10-13 Thread Franz Edler
Hello,

Can anyone please give me a hint what I can do that MySQL also listens to
the physical address of the host.
I see that MySQL listen only to 127.0.0.1:3306 and therefore every
connection via the physical interface is reset.

What can I do?

Regards
Franz


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: MySQL only listens on localhost

2007-10-13 Thread Patricio A. Bruna
Check for bind-address in your my.cnf file

- Franz Edler [EMAIL PROTECTED] escribió:
 Hello,
 
 Can anyone please give me a hint what I can do that MySQL also listens
 to
 the physical address of the host.
 I see that MySQL listen only to 127.0.0.1:3306 and therefore every
 connection via the physical interface is reset.
 
 What can I do?
 
 Regards
 Franz
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:   
 http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Res: MySQL only listens on localhost

2007-10-13 Thread Wagner Bianchi
After check the my.cnf, how said by friend Patricio, give the GRANT ALL ON *.* 
TO root@'%'; for thet user do the remote connections.
For some doubts, keep on list!

Bye!  
 
Wagner Bianchi
Diretor de Tecnologia - INFODBA Technologies  Consulting
[EMAIL PROTECTED] - +55 (31) 3272 - 0226 / 8427 - 8803
 



- Mensagem original 
De: Patricio A. Bruna [EMAIL PROTECTED]
Para: Franz Edler [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Enviadas: Sábado, 13 de Outubro de 2007 17:07:04
Assunto: Re: MySQL only listens on localhost

Check for bind-address in your my.cnf file

- Franz Edler [EMAIL PROTECTED] escribió:
 Hello,
 
 Can anyone please give me a hint what I can do that MySQL also listens
 to
 the physical address of the host.
 I see that MySQL listen only to 127.0.0.1:3306 and therefore every
 connection via the physical interface is reset.
 
 What can I do?
 
 Regards
 Franz
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:  
 http://lists.mysql.com/[EMAIL PROTECTED]


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]


  Abra sua conta no Yahoo! Mail, o único sem limite de espaço para 
armazenamento!
http://br.mail.yahoo.com/

Re: MySQL only listens on localhost

2007-10-13 Thread Jim Ginn
Franz:

Did you setup user access permissions outside of 127.0.0.1 and is port
3306 open on your firewall/router?

Jim Ginn
http://www.Tenant.com


 Hello,

 Can anyone please give me a hint what I can do that MySQL also listens to
 the physical address of the host.
 I see that MySQL listen only to 127.0.0.1:3306 and therefore every
 connection via the physical interface is reset.

 What can I do?

 Regards
 Franz


 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: MySQL only listens on localhost

2007-10-13 Thread Banyan He

Check your my.cf file a /etc/my.cf.

To add the bind-address = ip at the end of the file. Restart your 
mysql. And grant the access to the user who you want to connect your 
database from where you can accept.


Franz Edler wrote:

Hello,

Can anyone please give me a hint what I can do that MySQL also listens to
the physical address of the host.
I see that MySQL listen only to 127.0.0.1:3306 and therefore every
connection via the physical interface is reset.

What can I do?

Regards
Franz


  


--
Banyan He
MailWeb Security
Mobile: +86 13641777622
MSN: [EMAIL PROTECTED]
Skype: banyan.he
Email: [EMAIL PROTECTED]
AntiSpam Test: [EMAIL PROTECTED]
AntiVirus Test: [EMAIL PROTECTED]
Wemaster Mail: [EMAIL PROTECTED]
Website: http://www.rootong.com


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]