mysql主从复制

sql server安装教程：https://mp.weixin.qq.com/s/I6tS1hQzOOJYj5Cf2Wfraw
连接mysql出现错误:SQL Error (2013): Lost connection to MySQL server at ‘waiting for initial communication packet’, system error: 0
解决办法：打开my.ini，找到[mysqld]项，在其后加入一句：skip-name-resolve，保存，重启mysql服务即可
如果忘记密码：
添加登录跳过权限检查配置
修改my.cnf，在mysqld配置节点添加skip-grant-tables配置
[mysqld]
skip-grant-tables
https://segmentfault.com/a/1190000010867488
https://www.cnblogs.com/zgx/archive/2011/09/13/2174823.html
mysql> CHANGE MASTER TO
-> MASTER_HOST=‘192.168.239.133’,
-> MASTER_USER=‘test’,
-> MASTER_PASSWORD=‘123456’,
-> MASTER_LOG_FILE=‘mysql-bin.000002’,
-> MASTER_LOG_POS=120;