配置mysql主从命令

最新推荐文章于 2025-08-09 20:21:24 发布

原创最新推荐文章于 2025-08-09 20:21:24 发布 · 97 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库

change master to master_host='192.168.X.X',master_port=XXX,master_user='XXX',master_password='XXX',master_log_file='mysql-bin.0000XXX',master_log_pos=XXX;

CHANGE MASTER TO option [, option] ...

option:
MASTER_HOST = 'host_name'
| MASTER_USER = 'user_name'
| MASTER_PASSWORD = 'password'
| MASTER_PORT = port_num
| MASTER_CONNECT_RETRY = interval
| MASTER_LOG_FILE = 'master_log_name'
| MASTER_LOG_POS = master_log_pos
| 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_KEY = 'key_file_name'
| MASTER_SSL_CIPHER = 'cipher_list'