Previous Next

MySQL Replication

Setup 2 of 6

Give privileges to the slaves and display the current log position: 
mysql> GRANT REPLICATION SLAVE ON *.* TO 
       'repl'@'slave1.washington.edu' IDENTIFIED BY '??';

mysql> GRANT REPLICATION SLAVE ON *.* TO 
       'repl'@'slave2.washington.edu' IDENTIFIED BY '??';