After BR backup and restore of the TiDB cluster to a new cluster, the account passwords are not transferred to the new cluster

Translated
1

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

Original topic: BR备份恢复TIDB集群到新集群之后，账号密码没有到新集群

| username: Johnpan

Using BR to backup and restore a TiDB cluster to a new TiDB cluster, after completion, the account passwords from the old cluster did not migrate over. Does BR backup not include account passwords? If that’s the case, do the account passwords from the old cluster need to be manually dumped?

2
| username: 啦啦啦啦啦 | Original post link

Refer to this: https://docs.pingcap.com/zh/tidb/stable/br-usage-restore-for-maintain#恢复-mysql-数据库下的表

3
| username: Ming | Original post link

The backup does not include the original cluster’s account passwords.
You need to manually export and import them.
You can write a script to extract the user passwords and permissions and import them downstream.

4
| username: 啦啦啦啦啦 | Original post link

It is possible after version 6.2.

5
| username: Ming | Original post link

Yeah :clap:

6
| username: Johnpan | Original post link

Alright, we can only dump manually.

7
| username: 履霜知冰 | Original post link

The account password will not be imported automatically.

8
| username: Johnpan | Original post link

According to the BR documentation, starting from BR 5.1.0, full backups will include system tables. From BR 6.1, some system tables, including mysql.user, will be automatically imported. I’ll upgrade BR tomorrow and try backing up and restoring.

9
| username: Kongdom | Original post link

Got a new version knowledge point. It should be better to merge into 6.1. :wink:

10
| username: system | Original post link

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