Advertisement
Guest User

Untitled

a guest
Dec 3rd, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. ssh -L 3305:127.0.0.1:3306 tunneluser@192.168.0.105 -f -N
  2.  
  3. mysql> SHOW SLAVE STATUS G
  4. *************************** 1. row ***************************
  5. Slave_IO_State: Connecting to master
  6. Master_Host: 127.0.0.1
  7. Master_User: slave_user
  8. Master_Port: 3305
  9. ...
  10. Slave_IO_Running: Connecting
  11. Slave_SQL_Running: Yes
  12. ...
  13. Last_IO_Errno: 2003
  14. Last_IO_Error: error connecting to master 'slave_user@127.0.0.1:3305' - retry-time: 10 retries: 1
  15. ...
  16. 1 row in set (0.00 sec)
  17.  
  18. mysql -h 127.0.0.1 -P 3305 -u slave_user -p
  19.  
  20. sudo /usr/sbin/semanage port -a -t mysqld_port_t -p tcp 3305
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement