但我已经修改过了,master的my.ini原封不动,slave的my.ini我修改了端口(随便给个4402之类的),而且server-id = 2 # # The replication master for this slave - required master-host = 127.0.0.1 # # The username the slave will use for authentication when connecting # to the master - required master-user = slave # # The password the slave will authenticate with when connecting to # the master - required master-password = 123456 # # The port the master is listening on. # optional - defaults to 3306 master-port = 3306 # # binary logging - not required for slaves, but recommended log-bin=mysql-bin # # binary logging format - mixed recommended #binlog_format=mixed# 重试间隔时间10秒 #master-connect-retry = 10# 需要同步的数据库 #replicate-do-db = bookstore# 启用从库日志, 这样可以进行链式复制 #log-slave-updates# 从库是否只读,0表示可读写,1表示只读 #read-only = 1我修改了这些,有些我是手工加上去的,我是按照网上的做法去设置的。。是不是有什么问题吗?
当然是的必须启动,要不然怎么主怎么从呢?root 都无法显示 那也没啥帐号可显示了
但我已经修改过了,master的my.ini原封不动,slave的my.ini我修改了端口(随便给个4402之类的),而且server-id = 2
#
# The replication master for this slave - required
master-host = 127.0.0.1
#
# The username the slave will use for authentication when connecting
# to the master - required
master-user = slave
#
# The password the slave will authenticate with when connecting to
# the master - required
master-password = 123456
#
# The port the master is listening on.
# optional - defaults to 3306
master-port = 3306
#
# binary logging - not required for slaves, but recommended
log-bin=mysql-bin
#
# binary logging format - mixed recommended
#binlog_format=mixed# 重试间隔时间10秒
#master-connect-retry = 10# 需要同步的数据库
#replicate-do-db = bookstore# 启用从库日志, 这样可以进行链式复制
#log-slave-updates# 从库是否只读,0表示可读写,1表示只读
#read-only = 1我修改了这些,有些我是手工加上去的,我是按照网上的做法去设置的。。是不是有什么问题吗?