List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:April 10 2001 1:59pm
Subject:Re: Slave to host connection
View as plain text  
You granted the proper priveleges for the slave machine on the master as
specified in
the instructions?

You can ping each way?

You have the master and slave port numbers set the same?

They are both running the latest version?

Running out of ideas.

MCA Department PESIT wrote:
> 
> Hi,
>    i have edited the host file but still the error message is the same.
> There seems to be no problem in connecting the master to slave, but vice a
> versa, no luck.
> 
> [root@linux] ~# mysql -h 192.168.1.2 -u slave -p
> Enter password:
> ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111)
> 
> Mathew
> 
> At 09:07 AM 4/9/01 -0500, you wrote:
> >To eliminate DNS problems, put each machine in the others /etc/hosts
> >file.
> >
> >MCA Department PESIT wrote:
> > >
> > > Hi there,
> > >    the master is running on 192.168.1.2 and the slave on 192.168.1.5 ,
> yes,
> > > the master is running. the user name and password are correct. actually i
> > > dont think it gets to the state of actually verifying the user name and
> > > password. even if i do just a mysql -h 192.168.1.2 it gives me an
> immediate
> > > error
> > >
> > > at 192.168.1.5
> > >
> > > [root@linux] /var/lib/mysql# mysql -h 192.168.1.2 -P 3306 -u slave -p
> > > Enter password:
> > > ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111)
> > >
> > > there are no errors at the server side and the error log is clean
> > >
> > > Mathew
> > >
> > > ---------------------------------------------------------------------
> > > 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 <mysql-thread70943@stripped>
> > > To unsubscribe, e-mail
> > <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >---------------------------------------------------------------------
> >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 <mysql-thread70977@stripped>
> >To unsubscribe, e-mail <mysql-unsubscribe-mca=pes.edu@stripped>
> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Thread
Slave to host connectionMCA Department PESIT9 Apr
  • Re: Slave to host connectionGerald Clark9 Apr
    • Re: Slave to host connectionMCA Department PESIT10 Apr
  • Re: Slave to host connectionGerald Clark10 Apr
    • Re: Slave to host connectionMCA Department PESIT11 Apr
  • Re: Slave to host connectionGerald Clark11 Apr
RE: Slave to host connectionSimon Green10 Apr