ERROR 1198 (HY000): This operation cannot be performed with a running slave; run STOP SLAVE first

作者：知新_RL | 2024-02-28 17:17:17

踩

this operation cannot be performed with a running slave; run stop slave firs

我在MariaDB(Mysql)从库输入与主库的连接信息时发生错误

具体报错如下


Database changed
MariaDB [mysql]> CHANGE MASTER TO
    -> MASTER_HOST='192.168.1.142',
    -> MASTER_USER='root',
    -> MASTER_PASSWORD='root',
    -> MASTER_LOG_FILE='binlog.000018',
    -> MASTER_LOG_POS=472;
ERROR 1198 (HY000): This operation cannot be performed with a running slave; run STOP SLAVE first

解决办法，尝试停止slave，输入完连接信息在重新连接

命令：slave stop;

连接成功：

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/知新_RL/article/detail/160451