CODEWITHSUNDEEP
mysqlmysql-error-1064
user2316896
user2316896

Reputation: 29

Mysql not start on slave system on mysql Ver 14.14 Distrib 5.6.41, version (Mysql master salve replication)?

    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'

Upvotes: 1

Views: 941

Answers (1)

Scott Noyes
Scott Noyes

Reputation: 373

The master-host, -user, and -password option variables were removed from MySQL 5.5. Use the CHANGE MASTER statement instead.

https://dev.mysql.com/doc/refman/5.5/en/replication-options-slave.html#replication-optvars-slaves-obsolete

Upvotes: 2

Related Questions