How to Force Change the Root Password After Upgrading from 7.4 to 7.5

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

Original topic: 7.4升级7.5后root密码没了怎么强制改密码

| username: tidb狂热爱好者

After upgrading from 7.4 to 7.5, the root password is lost. How to forcibly change the password?

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

Forgot the root password? Check this document:

| username: 江湖故人 | Original post link

TiDB forces password changes just like MySQL.

| username: zhanggame1 | Original post link

What does it mean when the root password is gone? Does it mean you can log in without a password, or that any password you enter is incorrect?

| username: Kongdom | Original post link

You can refer to the practical operations of the column partners

| username: 这里介绍不了我 | Original post link

TiDB User Account Management | PingCAP Documentation Center

| username: TIDB-Learner | Original post link

The configuration file is different, but the steps are basically the same as recovering a password in MySQL.

| username: dba远航 | Original post link

Try skip-grant-table.

| username: wangccsy | Original post link

Modify the user table in the MySQL database.

| username: TiDBer_小阿飞 | Original post link

Why is the root password gone after the upgrade?