On the slave:
telnet 192.168.1.2 3306
DO you get a connected message and sone garbage?
If not, your master is not open for connections on port 3306.
You could have skip-networking in /etc/my.cnf , or perhaps you specified
a different
port.
If you did get the connection, then it is something else.
MCA Department PESIT wrote:
>
> i have granted the correct privileges to the slave machine on the
> master. like i said before it doesnt really come to that stage. had it come
> to that stage, it would have said something like Access Denied if the
> privileges were not proper.
>
> The 2 machines are able to ping each other. The versions are both
> new. for that matter, i created a user name on the slave machine and the
> master can connect to the slave using this.
>
> slave is 192.168.1.5
> master is 192.168.1.2
>
> i.e [at the master] mysql -h 192.168.1.5 -u master -p
> this is successful where master is a user name i created on the slave
> machine with appropriate privileges.
>
> [at the slave] mysql -h 192.168.1.2 -u slave -p
> does not work, where slave is a user name i created on the master
> machine with appropriate privileges.
>
> the error is
> [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)
>
> my etc/host file looks suspect, can you give me a typical example for a
> setup as mentioned above. although the entries seem okay, i will double
> check if you can give me a sample entry. my linux skills are limited hence
> the uncertainity.
>
> At 08:59 AM 4/10/01 -0500, you wrote:
> >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
