Skip to the content
moneyslow.com
  • link
  • vps
  • all
  • about

mysql主从配置视频

moneyslow | 2016-12-22

主库:
GRANT REPLICATION SLAVE ON *.* TO 'repl'@'10.0.0.1' IDENTIFIED BY 'password';
flush privileges;
从库:
CHANGE MASTER TO MASTER_HOST='10.0.0.1',master_user='repl',master_password='password',MASTER_LOG_FILE='mysql-bin.000152', MASTER_LOG_POS=1;
start slave;
show slave status\G;

Categories: 最新文章 标签:linux, mysql, mysql主从配置, 互联网技术

文章导航

← 视频:linux 下如何找到一个命令或文件
happy 2017 祝福新年快乐 →
© 2023 moneyslow.com
京ICP备11047313号-19