1\uff09\u5b89\u88c5mysql\uff1a\u7565<\/p>\n
2\uff09\u542f\u52a8mysqld:
\nmysqld<\/p>\n
3\uff09\u4fee\u6539mysql\u7684root \u7528\u6237\u7684password\uff1a
\nmysql -u root<\/p>\n
use mysql
\nupdate user set password=password(“<you password>”) where user=”root”;
\ngrant all privileges on *.* to root@’%’ identified by ‘<you password>’ with grant option;
\nflush privileges;<\/p>\n
quit;<\/p>\n
4\uff09\u7528\u4e0a\u8ff0\u65b9\u6cd5\uff0c\u5728\u53e6\u4e00\u53f0\u673a\u5668\u4e0a\u5b89\u88c5mysql\u3002<\/p>\n
5\uff09\u5728\u5176\u4e2d\u4e00\u53f0\u4e3b\u5e93\u4e0a\uff0c\u6267\u884c\uff1a<\/p>\n
mysql -u root -p<\/p>\n
grant replication slave on *.* to ‘root’@’%’ identified by ‘<your mysql pass for replicatoin>’;<\/p>\n
show master status;
\nflush privileges;
\n6)\u5728\u4ece\u5e93\u4e0a\uff0c<\/p>\n
vi mysql\/my.cnf\u4e2d\u7684server id \u4e3a2\uff08\u548c\u4e3b\u5e93\u4e0d\u540c\u5373\u53ef\uff09\u3002<\/p>\n
7\uff09\u5728\u4ece\u5e93\u4e0a\u6267\u884c\uff1a<\/p>\n
mysql -u root -p
\nCHANGE MASTER TO MASTER_HOST='<you master’s hostname>’, MASTER_PORT=<you master’s port>, MASTER_USER=’root’, MASTER_PASSWORD='<your mysql pass for replicatoin>’;<\/p>\n
8) \u4ece\u5e93\u542f\u52a8mysqld\uff1a
\nmysqld<\/p>\n
\u53ef\u4ee5\u89c2\u5bdf\u5230\u662f\u5426\u8fde\u63a5\u4e3b\u5e93\u6210\u529f\u3002<\/p>\n
9\uff09\u5728\u4e3b\u5e93\u4e0a\u521b\u5efa\u6570\u636e\u5e93\uff1a
\nmysql -u root -p<\/p>\n
create database pay;<\/p>\n
use pay\uff1b<\/p>\n
create table test(a int);
\ninsert into test values (1);<\/p>\n
\u4f1a\u770b\u5230\u4ece\u5e93\u4e0a\u4f1a\u81ea\u52a8\u521b\u5efa\u76f8\u540c\u6570\u636e\u5e93\uff0c\u5e76\u505a\u540c\u6b65\u3002<\/p>\n
10\uff09\u4ece\u4e3b\u5e93\u6216\u4ece\u5e93\u8fde\u63a5\u53e6\u4e00\u4e2a\u5e93\uff1a
\nmysql -h <remote host> –port=<remote port> -u <remote user> -p ‘<remote mysql user’s pass>’<\/p>\n
11\uff09\u5173\u95edmysql\uff1a
\nmysqladmin stop;<\/p>\n
<\/p>\n
\u6269\u5c55\uff1a<\/p>\n
\u5982\u679c\u60f3\u8ba9\u4ece\u5e93\u7684slave\u590d\u5236\u8fdb\u7a0b\u4e0d\u968fmysql\u542f\u52a8\u800c\u542f\u52a8\uff0c\u53ef\u4ee5\u5728my.cnf\u914d\u7f6eskip-slave-start\u53c2\u6570,\u8fd9\u6837\u590d\u5236\u8fdb\u7a0b\u5c31\u4e0d\u4f1a\u968f\u7740\u6570\u636e\u5e93\u7684\u542f\u52a8\u800c\u542f\u52a8\uff1a<\/p>\n