Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From: "Peter H. Coffin" <hellsop@ninehells.com>
Newsgroups: comp.databases.mysql
Subject: Re: modify my.cnf
Date: Thu, 21 Apr 2011 22:10:39 -0500
Organization: A noiseless patient Spider
Lines: 34
Message-ID: <slrnir1sdf.2mh.hellsop@nibelheim.ninehells.com>
References: <4cde199c-2021-4d9e-96ec-8947372893c2@a21g2000prj.googlegroups.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Injection-Info: mx02.eternal-september.org; posting-host="le/2G4+BNpieVhQI6uJ2Lw"; logging-data="12579"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX18cJqExpBzJegbVHrAuoxhu"
User-Agent: slrn/0.9.9p1 (OpenBSD)
Cancel-Lock: sha1:D1pckLjHnpBXhcvBgaJ4r9XzuNA=
Xref: x330-a1.tempe.blueboxinc.net comp.databases.mysql:589

On Thu, 21 Apr 2011 18:07:35 -0700 (PDT), jrough wrote:
> Below is my my.cnf. In this configuration I had wanted to use mysql
> and my web server on an outside IP but I discovered I can't because I
> have a software IP name, loopback from dyndns instead of a static IP
> number from AT&T.  So now I want to change it back to being how it
> should be for localhost testing only.  This configuration didn't work
> becuase you can't use a named host in mysql only an IP address.  Let
> me know if that changed for MySQL 5.5 .  It seems that you should be
> able to have a person hit the web server from the outside through the
> DYNDNS account and the port forwards to the localhost so anyway?
> thanks.
>
>
> user= root
> pid-file = /var/run/mysqld.pid
> port = 3306
> tmpdir = /tmp
> bind-address = 99.40.53.42
> basedir=/usr/local/mysql
> datadir=/usr/local/mysql-5.0.77-osx10.4-powerpc/data
> sort_buffer_size=2M
> default-storage-engine=myisam
>
> [client]
> socket=/tmp/mysql.sock

The answer is remove the above line that has *anything* to do with an IP
address.

You almost had it in your grasp this time!

-- 
Compared to system administration, being cursed forever is a step up.
              -- Paul Tomko