mysql 5.6 主从提示错误v_MySQL 5.6主从复制及遇到的错误

2、在主服务器上,设置一个从数据库的账户,使用REPLICATION SLAVE赋予权限

MySQL> grant replication slave on *.* to 'tt'@'192.168.254.153' identified by '123456';

Query OK, 0 rows affected (0.06 sec)

mysql> show master status \G;                查看当前master的二进制日志状态和起始点

*************************** 1. row ***************************

File: mysql-bin.000011

Position: 330

Binlog_Do_DB:

Binlog_Ignore_DB:

Executed_Gtid_Set:

1 row in set (0.01 sec)

mysql> flush tables with read lock;            将mysql的数据库锁表，仅仅允许读，以保证数据的一致性

Query OK, 0 rows affected (0.06 sec)

[root@localhost ~]# mysqldump -uroot -p123 blog  > blog.sql        将blog这个库以脚本的形式导出来，便于导入slave

mysql> unlock tables;                                              解锁

Query OK, 0 rows affected (0.00 sec)

3、 slave上的操作

[root@wordpress ~]# mysql -u root -p123456 < blog.sql

mysql> change master to master_host='192.168.2

54.46',master_user='master',master_password='m

aster',master_log_file='mysql-bin.000011',master_log_pos=330;

Query OK, 0 rows affected, 2 warnings (0.13 sec)

mysql> show slave status \G;

*************************** 1. row ***************************

Slave_IO_State:

Master_Host: 192.168.254.46

Master_User: master

Master_Port: 3306

Connect_Retry: 60

Master_Log_File: mysql-bin.000011

Read_Master_Log_Pos: 330

Relay_Log_File: wordpress-relay-bin.000001

Relay_Log_Pos: 4

Relay_Master_Log_File: mysql-bin.000011

Slave_IO_Running: No

Slave_SQL_Running: No

Replicate_Do_DB:

Replicate_Ignore_DB:

Replicate_Do_Table:

Replicate_Ignore_Table:

Replicate_Wild_Do_Table:

Replicate_Wild_Ignore_Table:

Last_Errno: 0

Last_Error:

Skip_Counter: 0

Exec_Master_Log_Pos: 330

Relay_Log_Space: 120

Until_Condition: None

Until_Log_File:

Until_Log_Pos: 0

Master_SSL_Allowed: No

Master_SSL_CA_File:

Master_SSL_CA_Path:

Master_SSL_Cert:

Master_SSL_Cipher:

Master_SSL_Key:

Seconds_Behind_Master: NULL

Master_SSL_Verify_Server_Cert: No

Last_IO_Errno: 0

Last_IO_Error:

Last_SQL_Errno: 0

Last_SQL_Error:

Replicate_Ignore_Server_Ids:

Master_Server_Id: 0

Master_UUID:

Master_Info_File: /database/master.info

SQL_Delay: 0

SQL_Remaining_Delay: NULL

Slave_SQL_Running_State:

Master_Retry_Count: 86400

Master_Bind:

Last_IO_Error_Timestamp:

Last_SQL_Error_Timestamp:

Master_SSL_Crl:

Master_SSL_Crlpath:

Retrieved_Gtid_Set:

Executed_Gtid_Set:

Auto_Position: 0

1 row in set (0.00 sec)

mysql> start slave;

Query OK, 0 rows affected (0.05 sec)