Error connecting to master: Can't connect to MySQL server on 'IPADDR # MUST BE SET' (111)

2004-12-20 Thread Terence
Hi, I am trying to setup replication on MySQL. Version 4.1.0alpha Using: ./bin/mysql -h IPADDR -u replication -p I can connect successfully, but my error logs show 041221 1:12:41 Slave I/O thread: error connecting to master 'replication # MU@IPADDR # MUST BE SET:3306': Error: 'Can't connect to

Re: Error connecting to master: Can't connect to MySQL server on 'IPADDR # MUST BE SET' (111)

2004-12-20 Thread Gleb Paharenko
Hello. When you are connecting using mysql, you usually don't specify the destination port. By default it's 3306. And at the same time master-port=. Send us complete contents of config files. What is in master error log? Check to what port slave instance is trying to connect (with

Re: Error connecting to master: Can't connect to MySQL server on 'IPADDR # MUST BE SET' (111)

2004-12-20 Thread Terence
I found that restarting the mysql server does not recreate the master.info file in the data directory. Although I had changed some settings in the /etc/my.cnf they did not populate the master.info file. So after banging my head for so many hours I deleted the master.info file and restarted the