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

On Thu, 21 Apr 2011 18:07:35 -0700 (PDT), jrough wrote:
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

On 4/21/2011 11:10 PM, Peter H. Coffin wrote:
Yea, but then *anyone* can get access to her database. Not a good idea
if you want to restrict that access, i.e. for security reasons, which is
what I think she's doing.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex (AT) attglobal (DOT) net
==================

On Fri, 22 Apr 2011 07:10:06 -0400, Jerry Stuckle wrote:
It's possible (and, yes, a very good idea), but it wasn't in the
original list of conditions. In fact, it was specifically mentioned that
outside access was something desired. But we both know that if you want
to limit where a connection *comes from*, that's a firewall issue or a
'user'@'address issue, not a my.cnf issue. Further, as shown, binding to
a specific external address would make that external access break when
the IP address eventually and inevitably changes. And that leaves us
with pretty much one solvable problem: IP address changed, external
access went away, tears were shed and teeth gnashed.

--
For their next act, they'll no doubt be buying a firewall running under
NT, which makes about as much sense as building a prison out of
meringue.
-- Tanuki