How to set up Users for Replication
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
|