mysql master + slave

http://forum.slime.com.tw/thread208827.html

 

aroot@agideo-desktop:~# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.0.38-Ubuntu_0ubuntu1.4-log Ubuntu 7.04 distribution

 

http://dev.mysql.com/doc/refman/5.0/en/replication-howto-repuser.html

mysql> GRANT REPLICATION SLAVE ON *.*
    -> TO 'repl'@'%.mydomain.com' IDENTIFIED BY 'slavepass';