moneyslow.com

Tag: mysql主从配置

  • mysql change master 语句备忘

    —

    from

    moneyslow
    of

    change master to master_host=’10.10.xx.xx’, master_port=3306, master_user=’repl’, master_password=’asdfasdfa’, master_log_file=’mysql-bin.004281′, master_log_pos=3234234;

  • mysql主从配置视频

    —

    from

    moneyslow
    of

    主库： 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;