Groups | Search | Server Info | Login | Register

Groups > comp.databases.mysql > #589

Re: modify my.cnf

Show all headers | 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