On Fri, May 10, 2002 at 10:23:30AM +0100, Raymond Brighenti wrote: > Hi, > > Trying to get replication going between to W2K machines and getting the > following errors in the Slave log file. > > MySql: ready for connections > 020509 18:58:52 Slave thread: error connecting to master:Can't connect to > MySQL server on '' (10049)(0), retry in 60 sec > 020509 18:59:54 Slave thread: error connecting to master:Can't connect to > MySQL server on '' (10049)(0), retry in 60 sec > 020509 19:00:57 Slave thread: error connecting to master:Can't connect to > MySQL server on '' (10049)(0), retry in 60 sec > > Below are the two my.cnf files which as far as I can see should be ok. > > my.cnf Master > [mysqld] > log-bin > server-id=1 > > my.cnf Slave > [MYSQLD] > master-host=20.0.0.54 > master-user=echo > master-password=<password> > master-port=3306 > server-id=2 > > Below are the output from some other checks, it's got the > "connecting to master" in the colum. Looking at the log file it's > getting the "MySQL server on ''" which seems to indicate that it > doesn't have a host or IP address to connect to! > > Any ideas?
Shut down the slave, blow away the master.info file, and start it back up. That should solve the problem. :-) Jeremy -- Jeremy D. Zawodny, <[EMAIL PROTECTED]> Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 92 days, processed 2,399,288,070 queries (301/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
