Re: How to set up Users for Replication

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 of 'itself'.

Marcus

-- 
Marcus Bointon
Synchromedia Limited: Creators of 
http://www.smartmessages.net/
UK resellers of info@hand CRM solutions
marcus(at)synchromedia.co.uk | 
http://www.synchromedia.co.uk/



-- 
MySQL Replication Mailing List
For list archives: 
http://lists.mysql.com/replication
To unsubscribe:    
http://lists.mysql.com/replication?unsub=lists@pantek.com