mysql 主从复制配置

MySQL主从

MySQL用户授权（主从数据库用户同步数据的登录身份）

bin-log日志（用于数据同步的依据）

MySQL主从复制（主数据库修改，从数据库随之变化）

准备：

两台Linux ContOS 6.* 

lamp环境已装好

IP地址：

    主服务器(master)    192.168.202.128

    从服务器(slave)     192.168.202.129

    本机windows           192.168.2.131

    三台电脑互通

主服务器master上操作：

mysql> select user,host,password from mysql.user;
+------+-----------------------+-------------------------------------------+
| user | host                  | password                                  |
+------+-----------------------+-------------------------------------------+
| root | localhost             | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| root | localhost.localdomain |                                           |
| root | 127.0.0.1             |                                           |
|      | localhost             |                                           |
|      | localhost.localdomain |                                           |
+------+-----------------------+-------------------------------------------+
5 rows in set (0.01 sec)

root用户，只能在本机master登录，下面试验看能否从其它电脑登录

从服务器slave上操作 mysql -ujack –p123 -h192.168.202.128 ERROR 1130 (HY000): Host '192.168.202.128' is not allowed to connect to this MySQL server 登录被拒绝，需要授权身份

一、授权

mysql> grant all on *.* to jack@192.168.202.129 identified by "123";

mysql> select user,host,password from mysql.user;
+------+-----------------------+-------------------------------------------+
| user | host                  | password                                  |
+------+-----------------------+