server-id=1
log-bin=/var/lib/mysql/mysql-bin.log
重启
show master statusG;
打开mysql
flush tables with read lock;
exit;
mysqldump -hlocalhost -uroot -p3306 -p test >/home/test.sql
cd /home
scp test.sql root@192.168.52.129:/home/
mysql
unlock tables;
grant replication slave on "." to 'slaveuser'@'192.168.52.129' identified by '123456'
从服务器
master-host=192.168.52.128
master-user=slaveuser
master-pass=123456
master-port=3306
master-connect-retry=60
replicate-do-db=test
show slave statusG
MySQL Error
Message: 没有连接到MySQL数据库
SQL:
Error: Lost connection to MySQL server at 'reading initial communication packet', system error: 110
Errno.: 2013
数据库在一台win2003上, 我用另一台linux连接报上面的错误, 可使用另一台win2003就可以连接成功。
my.ini 配置如下
[mysqld]
skip-name-resolve
skip-locking
max_allowed_packet=256M