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';
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.