主IP：10.114.213.215
从IP：10.114.213.216

  1. scp bonc@10.114.213.216:/data/bonc/bonc_soft/mysql-5.7.13-linux-glibc2.5-x86-64.tar.gz /data/bonc/bonc_soft
  2. tar -xvzf mysql-5.7.13-linux-glibc2.5-x86-64.tar.gz
  3. mkdir -p /data/bonc/bonc_work/mysql5.7.13
  4. cp -r ./* /data/bonc/bonc_work/mysql5.7.13
  1. vi /data/bonc/bonc_work/mysql5.7.13/support-files/mysql.server
  2. vi /data/bonc/bonc_work/mysql5.7.13/my.ini
  3. vi /data/bonc/bonc_work/mysql5.7.13/my.cnf
  1. /data/bonc/bonc_work/mysql5.7.13/bin/mysql_install_db --user=boncdj --basedir=/data/bonc/bonc_work/mysql5.7.13 --datadir=/data/bonc/bonc_work/mysql5.7.13/data
  1. mysql_home=/data/bonc/bonc_work/mysql5.7.13
  2. nohup ${mysql_home}/bin/mysqld --user=boncdj \
  3. --skip-grant-tables \
  4. --datadir=${mysql_home}/data \
  5. --basedir=${mysql_home} --lower-case-table-names=1 \
  6. --explicit_defaults_for_timestamp=true --log-bin=mysql-bin --server-id=1 \
  7. --bind-address=127.0.0.1 --sql_mode= --log_bin_trust_function_creators=1 \
  8. --transaction_isolation=READ-COMMITTED --binlog_format=mixed \
  9. --max_allowed_packet=104857600 \
  10. --lc_messages_dir=${mysql_home}/share --lc_messages=en_US \
  11. --character_set_server=utf8 --collation_server=utf8_general_ci \
  12. --log-error=${mysql_home}/log/myql.err \
  13. --pid-file=${mysql_home}/mysql.pid \
  14. --socket=${mysql_home}/my.socket --port=3306 &
  1. chmod 770 -R mysql5.7.13
  2. ./startup.sh
  1. /data/bonc/bonc_work/mysql5.7.13/bin/mysql -uroot -p -S '/data/bonc/bonc_work/mysql5.7.13/my.socket'
  2. update user set authentication_string=password("Bonc@123") where user='root';
  1. set password='Bonc@123';
  2. alter user 'root'@'localhost' password expire never;
  3. flush privileges;
  1. create user 'backup'@'localhost' identified by 'Bonc@20211220';
  2. grant replication slave on *.* to 'backup'@'%' identified by 'Bonc@20211220';
  3. grant all privileges on '.' to 'root'@'%' identified by 'Bonc@123' with grant option;
  4. flush privileges;
  1. show master status\G #
  1. ##在my.cnf中添加
  2. server_id=2
  3. master-info-repository=TABLE
  4. relay_log_info_repository=TABLE
  5. ##登录从库mysql,执行
  6. stop slave;
  7. change master to
  8.   master_host='10.11.213.215',
  9.   master_port=3306,
  10.   master_user=xxxxx,
  11.   master_password='xxxxxxx',
  12.   master_log_file='mysql-bin.000014',
  13.   master_log_pos=340;
  14. start slave;
  15. show slave status \G
  16. ##停止mysql服务
  17. ./mysql.server stop

在主库创建一个测试表