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 el
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
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
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 h
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
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 t
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
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