设置主从同步时,出现下面的问题:
MariaDB [(none)]> change master to master_host='192.168.118.159', master_user='song_rep', master_password='song_rep', master_port=3307, master_log_file='binlog.000005', master_log_pos=624;
ERROR 1201 (HY000): Could not initialize master info structure for ''; more error messages can be found in the MariaDB error log
查看日志文件
150207 22:36:06 [ERROR] Error reading master configuration
里面只有这一行。
重置salve之后,可以。
MariaDB [(none)]> reset slave;
Query OK, 0 rows affected (0.00 sec)
MariaDB [(none)]> change master to master_host='192.168.118.159', master_user='song_rep', master_password='song_rep', master_port=3307, master_log_file='binlog.000005', master_log_pos=624;
Query OK, 0 rows affected (0.04 sec)