修改主库的root密码后,运行错误

[taoyang987]

标准版部署的polardbx-engine:v2.4.1_8.4.19
修改主库的root密码后,
pod日志会提示
2024-12-05 15:08:36,602 - AuditController - ERROR - Creating mysql connection pool failed: 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[taoyang987]

kubectl apply -n polardbx-operator-system -f - <<EOF
apiVersion: polardbx.aliyun.com/v1
kind: XStore
metadata:
name: polardbx
namespace: polardbx-operator-system
spec:
config:
engine:
# mycnf 中的相关配置项
override:
value: |+
sql_mode = STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
group_concat_max_len=10240000
lower_case_table_names=1
default_time_zone= +08:00
controller:
RPCProtocolVersion: 1
topology:
nodeSets:
- name: cand
replicas: 2
role: Candidate
template:
spec:
image: polardbx-opensource-registry.cn-beijing.cr.aliyuncs.com/polardbx/polardbx-engine:v2.4.1_8.4.19
resources:
limits:
cpu: 2
memory: 4Gi
- name: log
replicas: 1
role: Voter
template:
spec:
image: polardbx-opensource-registry.cn-beijing.cr.aliyuncs.com/polardbx/polardbx-engine:v2.4.1_8.4.19
resources:
limits:
cpu: 1
memory: 2Gi
EOF

[taoyang987]

[taoyang987]

root密码重新改为空,但是从库还是报错
2024-12-05 15:15:39,989 - AuditController - ERROR - Creating mysql connection pool failed: 1862 (HY000): Your password has expired. To log in you must change it using a client that supports expired passwords.