Mysql replication

CHANGE MASTER TO MASTER_HOST = 'host_name', MASTER_USER = 'user_name', MASTER_PASSWORD = 'password', MASTER_PORT = port_num, MASTER_LOG_FILE = 'master_log_name', MASTER_LOG_POS = master_log_pos;

Full syntax: CHANGE MASTER TO option [, option] ... [ channel_option ]

option:

   MASTER_BIND = 'interface_name'
 | MASTER_HOST = 'host_name'
 | MASTER_USER = 'user_name'
 | MASTER_PASSWORD = 'password'
 | MASTER_PORT = port_num
 | MASTER_CONNECT_RETRY = interval
 | MASTER_RETRY_COUNT = count
 | MASTER_DELAY = interval
 | MASTER_HEARTBEAT_PERIOD = interval
 | MASTER_LOG_FILE = 'master_log_name'
 | MASTER_LOG_POS = master_log_pos
 | MASTER_AUTO_POSITION = {0|1}
 | RELAY_LOG_FILE = 'relay_log_name'
 | RELAY_LOG_POS = relay_log_pos
 | MASTER_SSL = {0|1}
 | MASTER_SSL_CA = 'ca_file_name'
 | MASTER_SSL_CAPATH = 'ca_directory_name'
 | MASTER_SSL_CERT = 'cert_file_name'
 | MASTER_SSL_CRL = 'crl_file_name'
 | MASTER_SSL_CRLPATH = 'crl_directory_name'
 | MASTER_SSL_KEY = 'key_file_name'
 | MASTER_SSL_CIPHER = 'cipher_list'
 | MASTER_SSL_VERIFY_SERVER_CERT = {0|1}
 | MASTER_TLS_VERSION = 'protocol_list'
 | MASTER_PUBLIC_KEY_PATH = 'key_file_name'
 | GET_MASTER_PUBLIC_KEY = {0|1}
 | IGNORE_SERVER_IDS = (server_id_list)

channel_option:

   FOR CHANNEL channel

server_id_list:

   [server_id [, server_id] ... ]