mysqlrouter: 2020-12-01 18:24:16: (ERROR) NR 000 Could not connect to any MySQL servers in the group 'default-replicas'. All connections failed. Errors: Access denied for user 'root'@'%'. Please check your credentials, group's metadata and server status. mysqlrouter: 2020-12-01 18:24:16: (ERROR) NR 000 Failed to route read/write connection: Hy000(1045) Access denied for user 'root'@'%'
这个错误表示MySQL Router无法连接到default-replicas组中的任何MySQL服务器,因为该组的元数据和服务器状态不符。并且,在连接时遇到了访问被拒绝的错误(Access denied for user ‘root’@’%’)。
对此,大家需要检查MySQL Router配置文件是否正确,特别是用户名和密码是否正确。若该配置无误,还需要检查MySQL服务器是否正常运行并且运行信息是否匹配MySQL Router的元数据。
[metadata_cache:ldap] method = ldap servers = ldap.example.com:389,ldap2.example.com:389 basedn = cn=mysqlrouter,dc=example,dc=com binddn = cn=mysqlrouter,dc=example,dc=com credentials = mypassword search_attrs = (objectClass=ippMysqlRouterGroup) [default-replicas] group_replication = 1 group_replication_group_name = "82949daa-6e42-4d5f-a29a-1e9d9ac17fac" group_replication_local_address = "10.0.1.203:3306" group_replication_auto_increment_offset = 2 group_replication_auto_increment_increment = 3 servers = example-1:3306,example-2:3306
如果配置文件检查完毕,而服务器状态未正常,则可以在MySQL服务器上检查错误日志以找出原因。如果问题仍存在,请安装更详细的日志记录功能,以更好地了解连接问题。