Master machine running Kubuntu 10.04, MySQL 5.1.41
Replication machine running Kubuntu 10.04, MySQL 5.1.41

Learning replication.

Attempting to set up replication of a small database. When I attempt to
start the slave i Get the error message:

ERROR 2003 (HY000) Can't connect to MySQL server on w.x.y.z (111)

from the slave machine, I can ping w.x.y.z.

I have tried to connect with several different users, but all return the
same error message.

Anything I look at says that the servers are running, correctly
configured, and ready to go.

So:
- what does the (111) at the end of the message tell me?
- What specific settings do I need to verify?
- What have I missed?

Thanks for your time.

William Colls wrote:
The above says otherwise :-)

I have found that on debian at least you need to reconfigure mysqld from
default to accept on other than the unix socket or the loopback interface.

I forget where the exact switch is, or what to do with it..mysqld.conf
probably.

William Colls <william.colls (AT) rogers (DOT) com> wrote:
Ping is not enough. The MySQL slave connects it's master
at TCP port 3306.

~ $perror 111
OS error code 111: Connection refused

Check firewalls. Check MySQL GRANT on the master.
You must create a slave user there and allow connections
from the slave IP (or name if you have working DNS)

You can test connection with the normal mysql command line
client. Just start it on the slave and try to connect to
the master, using slave user and password.


XL

On Jan 13, 3:30*pm, Axel Schwenke <axel.schwe... (AT) gmx (DOT) de> wrote:

Captain Paralytic wrote:
Oh no. The apostrophe wars have strayed again,..

On 13-01-2012 16:28, The Natural Philosopher wrote:
It's skip-networking

http://dev.mysql.com/doc/refman/5.1/...kip-networking

So, in your my.cnf you should NOT have a line:
skip-networking

Because, if you have that, MySQL wont listen on port 3306

You can verify that by doing this (on a linux prompt):
# netstat -antp | grep 3306
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 3522/mysqld



--
Luuk

On Jan 13, 4:48*pm, The Natural Philosopher <t... (AT) invalid (DOT) invalid>
wrote: