polardbx-sql
polardbx-sql copied to clipboard
polardb
修改主库的root密码后,运行错误
标准版部署的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)
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
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.