Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
en:how-to:how_to_set_up_master_slave_replication_in_mysql [2016/12/28 02:58]
liuxl
en:how-to:how_to_set_up_master_slave_replication_in_mysql [2017/12/12 03:05] (current)
Line 41: Line 41:
 <​code>​ grant replication slave on *.* to '​master'​@'​192.168.1.248'​ identified by '​123456';​ </​code>​ <​code>​ grant replication slave on *.* to '​master'​@'​192.168.1.248'​ identified by '​123456';​ </​code>​
  
-<note tip>​Solve the grant replication slave on operation prompt password PASSWORD () error, execute command ​"show variables like '​old_passwords';​" ​If "​old_passwords = 1", execute command ​"set old_passwords = 0;" ​solve the problem.+<note tip>​Solve the grant replication slave on operation prompt password PASSWORD () error, execute command: 
 +<​code>​show variables like '​old_passwords';​</​code>​ 
 +If "​old_passwords = 1", execute command: 
 +<​code>​set old_passwords = 0;</​code>​ 
 +solve the problem.
 </​note>​ </​note>​
  
Line 84: Line 88:
 {{:​zh:​常见问题及解答:​selection009.png?​750|}} {{:​zh:​常见问题及解答:​selection009.png?​750|}}
  
-<note tip>If the master with mysql5.6, binlog_checksum default is set to "​crc32",​ and slave with the 5.5 or earlier version, the master of the binglog_checksum set to none. You can execute set global binlog_checksum = '​NONE'​ on the console, or write my.cnf, and add binlog_checksum = NONE.</​note>​+<note tip>If the master with mysql5.6, binlog_checksum default is set to "​crc32",​ and slave with the 5.5 or earlier version, the master of the binglog_checksum set to none. You can execute
 +<​code>​set global binlog_checksum = '​NONE'​</​code>​ 
 +on the console, or write my.cnf, and add
 +<​code>​binlog_checksum = NONE</​code>​.</​note>​
en/how-to/how_to_set_up_master_slave_replication_in_mysql.txt · Last modified: 2017/12/12 03:05 (external edit)
Recent changes RSS feed Debian Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki