RE: MySQL only listens on localhost
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
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
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
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
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
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]