Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CHANGE MASTER TO MASTER_HOST='[IP OF MASTER SERVER]', MASTER_USER='replication_user',
- MASTER_PASSWORD='[PASSWORD]', MASTER_PORT=[PORT], MASTER_LOG_FILE='master1-
- bin.000001', MASTER_LOG_POS=42266, MASTER_CONNECT_RETRY=10;
- Last_IO_Error: error connecting to master 'replication_user@[IP]:[PORT]' - retry-time: 10 maximum-retries: 86400 message: Can't connect to MySQL server on '[IP]' (13 "Permission denied")
- mysql -ureplication_user -p[PASSWORD] -h [IP] -P [PORT]
- CREATE USER ‘replication_user’@’%’ INDETIFIED BY ‘[PASSWORD]’;
- GRANT REPLICATION SLAVE ON *.* TO ‘replication_user’@’%’;
Add Comment
Please, Sign In to add comment