semicolon.in.th Programming is real fun!

[Master] = Master database server
[Slave] = Slave database server

Scenario
We would like to setup 1:1 Master-Slave MySQL Replication.

Environment
[Master]
OS: Fedora 9
IP: 192.168.0.40

[Slave]
OS: Fedora 9
IP: 192.168.0.41

Step-by-step guide for MyISAM tables
1. At [Master], grant replication privileges for [Slave]

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

Note: We will use "Username" (repl) and "Password" (slavepass) in step 10.