Guest User

Untitled

a guest
Dec 15th, 2018
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. CHANGE MASTER TO MASTER_HOST='[IP OF MASTER SERVER]', MASTER_USER='replication_user',
  2. MASTER_PASSWORD='[PASSWORD]', MASTER_PORT=[PORT], MASTER_LOG_FILE='master1-
  3. bin.000001', MASTER_LOG_POS=42266, MASTER_CONNECT_RETRY=10;
  4.  
  5. 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")
  6.  
  7. mysql -ureplication_user -p[PASSWORD] -h [IP] -P [PORT]
  8.  
  9. CREATE USER ‘replication_user’@’%’ INDETIFIED BY ‘[PASSWORD]’;
  10. GRANT REPLICATION SLAVE ON *.* TO ‘replication_user’@’%’;
Add Comment
Please, Sign In to add comment