Hi there
If you set the IP in mysql DB to localhost can you log on then with the
right password and user name..?
If you can the try changing it back.
I always for get to flush my tables.....!!!!!
Simon
-----Original Message-----
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: 10 April 2001 14:59
To: MCA Department PESIT
Cc: [EMAIL PROTECTED]
Subject: Re: Slave to host connection
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
