From owner-freebsd-questions Sat May 4 23: 3:37 2002 Delivered-To: freebsd-questions@freebsd.org Received: from spitfire.velocet.net (spitfire.velocet.net [216.138.223.227]) by hub.freebsd.org (Postfix) with ESMTP id 8F49637B400 for ; Sat, 4 May 2002 23:03:34 -0700 (PDT) Received: from wenk (H204.C233.tor.velocet.net [216.138.233.204]) by spitfire.velocet.net (Postfix) with SMTP id D8CB6FB4618 for ; Sun, 5 May 2002 02:03:32 -0400 (EDT) Message-ID: <000901c1f414$36f6ed00$b300a8c0@wenk> From: "Jeff Shevlen" To: Subject: mysql & ISP hostname Date: Sun, 5 May 2002 02:06:59 -0700 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Hi, I have a question about ISP assigned hostnames and MySQL. I want to change how MySQL recognizes my machine in the mysql.user table. Say my machine's name is www.my.url. To initialize the remote login for root I did this: % mysqladmin -u root -h www -p password 'secretpassword' mysqladmin: connect to server at 'www' failed error: 'Host 'xxx.xxx.my.isp.net' is not allowed to connect to this MySQL server' Fine, so I went into mysql.user and changed every 'www' entry to 'xxx.xxx.my.isp.net'. Now: % mysqladmin -u root -h ''xxx.xxx.my.isp.net' -p password 'secretpassword' ... works: MySQL recognizes my machine's hostname. The problem is, as far as solutions go, this is a pretty inelegant. I have a static IP, and I have a FQDN, and I want to use these with MySQL for obvious reasons. I don't know how MySQL manages it's networking, but is there a way to change this behavior? Is there maybe some way to have MySQL do a DNS lookup (or use /etc/hosts somehow...) so I don't have to use the ISP's assigned name? Jeff To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message