参考博客：

​​https://blog.csdn.net/qq_45562888/article/details/122438129?spm=1001.2101.3001.6650.5&utm_medium=distribute.wap_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromBaidu%7Edefault-5-122438129-blog-120478300.wap_relevant_multi_platform_whitelistv1&depth_1-utm_source=distribute.wap_relevant.none-task-blog-2%7Edefault%7EBlogCommendFromBaidu%7Edefault-5-122438129-blog-120478300.wap_relevant_multi_platform_whitelistv1​​

8.0 遇到的问题：

在从库上执行 show slave status\G

显示报错：

Last_IO_Error: error connecting to master 'repl@127.0.0.1:3316' - retry-time: 60 retries: 2 message: Authentication plugin 'caching_sha2_password' reported error: Authentication requires secure connection.

考虑到我的MySQL8 

查看主库：

SELECT plugin FROM `user` where user = 'repl';

原来是主库repl的plugin是caching_sha2_password 导致连接不上，修改为mysql_native_password即可解决。

ALTER USER 'repl'@'%' IDENTIFIED WITH mysql_native_password BY 'root';