hi everybody:
I've problem in setup my mysql replication.The following is my configuration:
for master:I add server-id=1,log-bin in my.cnf.
After that i issue the mysql command GRANT FILE ON . TO replicate@10.0.48.118 IDENTIFIED BY 'enter' /g.Then it will come out the result query OK,0 row affect something like that.
for slave:I add server-id=2,master-host=10.0.48.14,master-user=replicate,master-password=enter.After that i issue the mysql command show slave status /g but no result,it only prompt me mysql> only.Why?
But for my master i keep geting the bin file and nothing in slave.Any thing that i need to add or configure.Thanks
cheng