1045 | error connecting to master 'slave_user@192.168.0.75:3306' - retry-time: 6 原因: 其实是MySQL的验证没有通过 解决: 主要是主从服务器上的密码不正确导致。需要检查master和slave中的配置, master GRANT REPLICATION SLAVE ON *.* TO 'slave_user'@'%' IDENTIFIED BY '123456'; slave CHANGE MAST...
Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 1045 Last_IO_Error: error connecting to master 'repl@master_ip_address:3306' - retry-time: 60 retries: 1 Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 0 ...
2017-04-21T13:46:15.133435Z 8806 [ERROR] Slave I/O for channel '': error connecting to master 'repl@192.168.2.40:3306' - retry-time: 60 retries: 1, Error_code: 1045 首先查看slave的错误日志文件,和上面的错误一样 接着用perror查看上一部获得的错误代码: [root@iZ2ze5ifr62amhrpcnpn9yZ m...
MASTER_HOST 填Navicat连接配置中的ip应该就可以 MASTER_PORT 主容器的端口 MASTER_USER 同步账号的用户名 MASTER_PASSWORD 同步账号的密码 检查是否配置成功 Slave_IO_State 如果是Waiting for master to send event,那么就成功一半了,如果是Connecting to master,基本就是配置失败了,建议重新检查下配置,具体失败的原...
2017-04-21T13:46:15.133435Z 8806 [ERROR] Slave I/O for channel '': error connecting to master 'repl@192.168.2.40:3306' - retry-time: 60 retries: 1, Error_code: 1045 首先查看slave的错误日志文件,和上面的错误一样 接着用perror查看上一部获得的错误代码: ...
1.Slave I/O: error connecting to master 'backup@192.168.1.x:3306'-retry-time: 60 retries: 86400,Error_code:1045 解决方法: 从服务器上删除掉所有的二进制日志文件,包括一个数据目录下的master.info文件和hostname-relay-bin开头的文件。 master.info::记录了Mysql主服务器上的日志文件和记录位置、连接...
Last_IO_Errno: 1045 Last_IO_Error: error connectingtomaster'replication@10.24.54.18:3306'- retry-time: 60 retries: 86400 Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 2 1 rowinset(0.00 sec) -- 报错如下: Last_IO_Errno: 1045ERROR: No query specified ...
Last_IO_Errno: 1045 Last_IO_Error: error connecting to master 'uk_slave_user@ccukdb1.domain.int:3306' – retry-time: 60 retries: 86400 Error 1045 indicates a credential error, but the credentials otherwise work correctly. One caveat: these are both virtual machines, with the slave being ...
1044 ER_DBACCESS_DENIED_ERROR Access denied for user '%s' to database '%s' 1045 ER_ACCESS_DENIED_ERROR Access denied for user '%s' (using password: %s) 1046 ER_NO_DB_ERROR No database selected 1047 ER_UNKNOWN_COM_ERROR Unknown command 1048 ER_BAD_NULL_ERROR Column '%s' cannot...
1044 42000 ER_DBACCESS_DENIED_ERROR Access denied for user '%s'@'%s' to database '%s' 1045 28000 ER_ACCESS_DENIED_ERROR Access denied for user '%s'@'%s' (using password: %s) 1046 3D000 ER_NO_DB_ERROR No database selected 1047 08S01 ER_UNKNOWN_COM_ERROR Unknown command 1048 23000 ...