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
> > >
> > >---------------------------------------------------------------------
> > >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
---------------------------------------------------------------------
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
