Mysql主从数据库配置

[client]

port=7778

[mysql]

default-character-set=latin1


# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this 
# file.
#
[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=7778
server-id=2
master-host=127.0.0.1
master-user=root
master-password =root
master-port=  3306
replicate-do-db=easyui

#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL2/"

#Path to the database root
datadir="C:/Program Files/MySQL/MySQL2/Data/"

 

[client]

port=3306

[mysql]

default-character-set=latin1


# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it reads this 
# file.
#
[mysqld]

# The TCP/IP Port the MySQL Server will listen on
port=3306
server-id=1
binlog-do-db=easyui
log-bin=mysql-bin

#Path to installation directory. All paths are usually resolved relative to this.
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"

#Path to the database root
datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"

 

 登陆主数据库：mysql -uroot -proot;

 

 

同步账号实质上是供从端使用的。

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;

这句的意思说允许root用户以root为密码从任意网段远程登陆10.86.21.147（主端）

 

查看主数据库状态：

 

登陆从数据库查看从数据状态：

 

 

状态如上图：必须保证有两个yes，同事Master_Log_file与主数据库中的file为同一个，以及Read_Master_Log_pos也要与主数据库中的Position相同