2020-02-10T11:00:53.415057Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 2 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:01:53.420131Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 3 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:02:53.424220Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 4 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:03:53.429087Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 5 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:04:53.433366Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 6 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:05:53.437484Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 7 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:06:53.440067Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 8 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:07:53.445776Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 9 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:08:53.450953Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 10 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:09:53.455924Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 11 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:10:53.459021Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 12 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:11:53.464126Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 13 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:12:53.468037Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 14 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:13:53.472272Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 15 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:14:53.473742Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 16 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:15:53.478213Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 17 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:16:53.482333Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 18 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:17:53.484064Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 19 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:18:53.488469Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 20 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:19:53.492874Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 21 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
2020-02-10T11:20:53.495222Z 5 [ERROR] [MY-010584] [Repl] Slave I/O for channel '': error connecting to master 'trigget@mysql-master:3306' - retry-time: 60 retries: 22 message: Access denied for user 'trigget'@'mysql-master' (using password: YES), Error_code: MY-001045
mysql 主從服務已啟動
查看master庫狀態
slave 庫狀態
經反復排查分析，排除以下幾點問題：
1、檢查Linux服務器埠正常：排除
netstat -apn | grep 3306
2、檢查Linux防火墻全部都關閉了,排除
3、網路不通排除
uj5u.com熱心網友回復：
主從同步的話，需要有個用戶在另一個MySQL資料庫上的登錄權限，這個用戶權限配置好了嗎uj5u.com熱心網友回復：
IO線序是NO 必須IO和SQL兩天線序都是yes 才可以實作主從同步。uj5u.com熱心網友回復：
收到！謝謝大佬指導，由于第一次搭建還請多加指點轉載請註明出處，本文鏈接：https://www.uj5u.com/caozuo/19346.html
標籤：專題技術討論區