On Sat, 30 Jul 2011 11:21:21 +0100, The Natural
Philosopher <tnp (AT) invalid (DOT) invalid> wrote:

Indeed.
Best regards,
--
( Kees Nuyt
)
c[_]

On 7/30/2011 6:19 AM, Kees Nuyt wrote:
Yes I am. Check the documentation. 0.0.0.0 is the default.

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

On Jul 28, 5:00*am, Axel Schwenke <axel.schwe... (AT) gmx (DOT) de> wrote:
Resolved: in the default my.cnf supplied with Ubuntu is an entry
"bind-address = 127.0.0.1"
which prevents the mysql daemon from accepting connections other than
locally.

Commenting out this entry fixed the problem and replication is working
well.
This brings up 2 questions:
1) how does phpmyadmin connect from a remote computer (and it did) ?
2) rather than leaving it wide open, what can I put for bind-address
to allow both local access and replication from a remote IP address ?

bill

bill wrote:
you must have told it where to look? Or was it running on the remote
mnchine ?


I answered that already. The answer is nothing at the mysqld level.
You need to install and configure iptables.

Oh. Its on the system by default in Ubuntu.

This may help

https://help.ubuntu.com/10.04/server.../firewall.html


But that takes us off the scope of this NG, so try comp.os.linux.misc or
one of the ubuntu fora.

> bill

On 7/30/2011 10:28 AM, bill wrote:
1) PHPMyAdmin was running on the server, so the connection was local
2) Set up your server's firewall properly. MySQL can't handle two
different ip addresses.

However, accessing MySQL through "localhost" (vs. 127.0.0.1) will use a
Unix socket, not the TCP/IP port. It's another way MySQL is screwed up
- it doesn't honor the standard for "localhost".

Now someone will hop in here and say you can do it by specifying your
user id as coming from the slave, i.e. slaveuser'@'192.168.1.105. But
that just limits this user to be connect from this address; it doesn't
stop other connections (and other MySQL users which may have been
created with a generic address).

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

phpmyadmin involves a connection from PHP on the web server to the
MySQL server. If both are on the local host, that explains why it
works. It's irrelevant where the web browser is.

bind-address is not a firewall. It's supposed to specify a local
IP address on the server machine. 0.0.0.0 represents 'all of them'.
You get the choice: local only, or let the world in.


If you want a firewall, install and use one. You can use user@IP_address
logins to restrict a particular login to come from a particular IP
address. That doesn't prevent some other IP address from repeatedly
trying to connect and loading down your server. And if there's a
bug in the server (regardless of whether it's MySQL, Oracle, Postgres,
or whatever) they might manage to get in or crash your server. You
probably want to firewall off the Internet at large from any database
server.

The Natural Philosopher <tnp (AT) invalid (DOT) invalid> wrote:
This is not the default. Some distributors might put such a line
in the my.cnf. But this is a poor decision unless they ask for
confirmation that this MySQL server is only to be used locally.


XL

Axel Schwenke wrote:
well that is as may be.

It is certainly the default in Debian.

Anyway, the main thing is the OP's question was answered.

Very few people do run mysql remotely, in the 'newbie' class, and those
who don't are usually able to work through the config file changes
successfully.

So I think its a decent enough default.