Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Re: How to set up Users for Replication

From: Jesse <jlc(at)msdlg.com>
Date: Mon Oct 08 2007 - 16:38:17 EDT


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

Thanks,
Jesse

-- 
MySQL Replication Mailing List
For list archives: 
http://lists.mysql.com/replication
To unsubscribe:    
http://lists.mysql.com/replication?unsub=lists@pantek.com
Received on Mon Oct 8 16:38:40 2007

This archive was generated by hypermail 2.1.8 : Fri Jul 04 2008 - 00:24:04 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library