User Tools

Site Tools


mysqlreplication

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
mysqlreplication [2019/02/19 14:21] – z0hpvkmysqlreplication [2019/03/10 20:35] (current) – z0hpvk
Line 16: Line 16:
 ==== Create Replication User on Master ==== ==== Create Replication User on Master ====
 <code> <code>
-create user 'repl'@'ubuntu-slave' identified by 'ipswich';+create user 'repl'@'ubuntu-slave' identified by 'teapot';
 grant replication slave on *.* to 'repl'@'ubuntu-slave'; grant replication slave on *.* to 'repl'@'ubuntu-slave';
 </code> </code>
Line 47: Line 47:
        ->     MASTER_HOST='ubuntu-master',        ->     MASTER_HOST='ubuntu-master',
        ->     MASTER_USER='repl',        ->     MASTER_USER='repl',
-       ->     MASTER_PASSWORD='welcome123',+       ->     MASTER_PASSWORD='teapot',
        ->     MASTER_LOG_FILE='binlog.000011',        ->     MASTER_LOG_FILE='binlog.000011',
        ->     MASTER_LOG_POS=904;        ->     MASTER_LOG_POS=904;
mysqlreplication.1550586116.txt.gz · Last modified: (external edit)