| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
connection slave; |
| 4 |
connection master; |
| 5 |
grant replication slave on *.* to replicate@localhost identified by 'aaaaaaaaaaaaaaab'; |
| 6 |
grant replication slave on *.* to [email protected] identified by 'aaaaaaaaaaaaaaab'; |
| 7 |
connection slave; |
| 8 |
include/start_slave.inc |
| 9 |
connection master; |
| 10 |
create table t1(n int); |
| 11 |
insert into t1 values(24); |
| 12 |
connection slave; |
| 13 |
select * from t1; |
| 14 |
n |
| 15 |
24 |
| 16 |
connection master; |
| 17 |
drop table t1; |
| 18 |
delete from mysql.user where user="replicate"; |
| 19 |
include/rpl_end.inc |