Skip to content

Instantly share code, notes, and snippets.

@futeng

futeng/create_rpl_user.sql

Created May 23, 2017 14:51
Show Gist options
  • Save futeng/d8addf661006cd64fcd653a7baa68583 to your computer and use it in GitHub Desktop.
Save futeng/d8addf661006cd64fcd653a7baa68583 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
create_rpl_user.sql
SET SQL_LOG_BIN=0;
CREATE USER rpl_user@'%';
GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%' IDENTIFIED BY 'rpl_pass';
SET SQL_LOG_BIN=1;
CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='rpl_pass' FOR CHANNEL 'group_replication_recovery';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment