On 8 Oct 2007, at 21:38, Jesse wrote:
>> On the server. Think of the slave as a client that needs to log in
>> to the master to fetch updates, and just as you might expect, you
>> need to set permissions on the server, and use them in your
>> CHANGE MASTER options on the slave.
> OK, so I add a user named Replication@DLGSrv on the master, right,
> and give it REPLICATION rights? What user will it use on the slave
> to execute the commands it finds in the BIN LOG on the master?
> Does it by-pass the user system on the slave to do this?
Yes. The slave connects to the master using the replication user
info, retrieves the changes from the master's binary log and applies
the changes locally. The master is a passive data source. There isn't
a local user to speak of at the slave end, you're giving the slave
the ability to do this at a global level, so it has an implicit user
Synchromedia Limited: Creators of http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus@stripped | http://www.synchromedia.co.uk/