MySQL14.14发行版5.6.41版本(MySQLmaster salve replication)上的从系统上MySQLnot start?

kd3sttzy  于 2021-06-21  发布在  Mysql
关注(0)|答案(1)|浏览(262)
My Configuration:
    server-id = 2
    master-host=192.1.1.12
    master-connect-retry=60
    master-user=root
    master-password=root123
    replicate-do-db=testdatabase
    relay-log = /var/lib/mysql/mysql-relay-bin
    relay-log-index = /var/lib/mysql/mysql-relay-bin.index
    log-error = /var/lib/mysql/mysql.err
    master-info-file = /var/lib/mysql/mysql-master.info
    relay-log-info-file = /var/lib/mysql/mysql-relay-log.info
    log-bin = /var/lib/mysql/mysql-bin
Output:

2018-09-14 08:41:10 13635 [ERROR] /usr/sbin/mysqld: unknown variable 'master-host=192.1.1.12'
2018-09-14 08:41:10 13635 [ERROR] Aborting    
2018-09-14 08:41:10 13635 [Note] Binlog end
2018-09-14 08:41:10 13635 [Note] Shutting down plugin 'partition'
2018-09-14 08:41:10 13635 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
wgx48brx

wgx48brx1#

主主机、-user和-password选项变量已从MySQL5.5中删除。改用change master语句。
https://dev.mysql.com/doc/refman/5.5/en/replication-options-slave.html#replication-optvars从机过时

相关问题