Re: modify my.cnf

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> (permalink)
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

Show key headers only | View raw

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

Back to comp.databases.mysql | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

modify my.cnf jrough <janis.rough@gmail.com> - 2011-04-21 18:07 -0700
  Re: modify my.cnf "Peter H. Coffin" <hellsop@ninehells.com> - 2011-04-21 22:10 -0500
    Re: modify my.cnf Jerry Stuckle <jstucklex@attglobal.net> - 2011-04-22 07:10 -0400
      Re: modify my.cnf "Peter H. Coffin" <hellsop@ninehells.com> - 2011-04-22 08:19 -0500
        Re: modify my.cnf jrough <janis.rough@gmail.com> - 2011-04-22 07:50 -0700
          Re: modify my.cnf Jerry Stuckle <jstucklex@attglobal.net> - 2011-04-22 11:12 -0400
          Re: modify my.cnf "Peter H. Coffin" <hellsop@ninehells.com> - 2011-04-22 14:47 -0500
            Re: modify my.cnf jrough <janis.rough@gmail.com> - 2011-04-23 09:15 -0700

csiph-web