Forum Debian Users Gang

server-id               = 1
log_bin                 = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
 max_binlog_size         = 100M
binlog_do_db            = test_replication

server-id       = 2
#
# The replication master for this slave - required
master-host     =   10.0.1.3
#
# The username the slave will use for authentication when connecting
# to the master - required
master-user     =   slave_user
#
# The password the slave will authenticate with when connecting to
# the master - required
master-password =   qwermnb
master-connect-retry=60
replicate-do-db=test_repliaction

mysql> CHANGE MASTER TO MASTER_HOST='10.0.1.3',MASTER_USER='slave_user',MASTER_P
ASSWORD='qwermnb',MASTER_LOG_FILE='mysql-bin.000002',MASTER_LOG_POS=98;
Query OK, 0 rows affected (0.07 sec)

mysql> LOAD DATA FROM MASTER;
ERROR 1219 (HY000): Error running query on master: Access denied; you need the R
ELOAD privilege for this operation