Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

How to set up Users for Replication

From: Jesse <jlc(at)msdlg.com>
Date: Mon Oct 08 2007 - 13:43:01 EDT


In reading through the instructions for setting up replication, it recommends setting up a user that will be used just for replication. So, I created a user named Replication and did a "GRANT REPLICATION SLAVE ON..." command. However, the instructions don't say if I need to do this on the slave, or on the master, or both. Also, do I create a Replication@LocalHost on the slave and a Replication@myserver on the master? or create a Replication@myserver on both master and server, or a Replication@localhost on both?

Also, should the GRAND REPLICATION SLAVE ON... command be executed on the master or the slave or both?

The instructions don't seem very clear on 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 13:43:27 2007

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


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