Error When Changing Root Password in TiDB

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: tidb修改root密码报错

| username: yulei7633

Error when changing the root password in TiDB

  1. First execute:
    tiup cluster edit-config tidb-test

  2. Then execute:
    tiup cluster reload tidb-test

  3. The TiDB cluster is deployed on a single machine. SSH is interconnected.

| username: yulei7633 | Original post link

There shouldn’t be any issues with the process of changing the password, so why is this error being reported? I can’t find the reason for a while.

| username: zhanggame1 | Original post link

Don’t change it like this. Directly log in to the TiDB server machine, modify the TiDB server configuration file tidb.toml, then use systemctl to restart the TiDB service, and finally log in locally to change the password.

| username: 像风一样的男子 | Original post link

The official documentation provides instructions on how to reset the password if you forget it, not like what you mentioned.

| username: yulei7633 | Original post link

Tested, this modification works.

| username: yulei7633 | Original post link

Thank you.

| username: dba远航 | Original post link

Modifications should be possible, but the original mutual trust should be re-established.

| username: lemonade010 | Original post link

According to the official documentation, make modifications.

| username: wangccsy | Original post link

It shouldn’t be.

| username: yulei7633 | Original post link

According to the official modifications, there are no issues.

| username: TIDB-Learner | Original post link

The importance of reading documentation.

| username: 数据源的TiDB学习之路 | Original post link

You can refer to my article Column - Forgot the root password for TiDB? Here’s a trick to solve it | TiDB Community

| username: WinterLiu | Original post link

Got it, to summarize, it’s still similar to the modification method of MySQL.

| username: kelvin | Original post link

Check the official documentation for modifications.

| username: TiDBer_lBAxWjWQ | Original post link

Just follow the official documentation.

| username: lemonade010 | Original post link

Refer to the official documentation.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.