On Wed, Mar 11, 2009 at 4:03 PM, Bryan Irvine <sparctacus@stripped> wrote:
> I've got 2 questions about my newly set up master->slave replica.
> 1> When I run "load data from master;" I get an error that I do not
> have RELOAD privileges and then it boots the slave offline.
> I've run GRANT SELECT, PROCESS, FILE, SUPER, REPLICATION CLIENT,
> REPLICATION SLAVE, RELOAD ON *.* TO root@'%' IDENTIFIED BY 'password';
> flush privileges;
> but it still does the same thing.
> 2> Is there a way to get a slave to automatically re-connect as the
> slave without having to know the masters binlog and position? Each
> time it reboots I have to manually add it back in with the change
> master to ... command.
#1. "This feature is deprecated. We recommend not using it anymore. It
is subject to removal in a future version of MySQL."
#2. Replication info should be being recorded on the master.info in
your data dir.