The root account's modifications to the database are not effective

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

Original topic: root账户修改库中的数据不生效

| username: TiDBer_EZRFJMZK

[Test Environment] TiDB
[TiDB Version] v4.0.16
[Reproduction Path] Modifying a specific data entry in a table does not take effect
[Encountered Problem: Phenomenon and Impact]
Query data as shown in the figure credit_code=914304827828692797


Modify data, execution shows success

Reopen the window to query, the data has not changed credit_code=914304827828692797

| username: Kongdom | Original post link

I’ve never encountered this before. Could it be that another program is continuously updating the data?

| username: TiDBer_EZRFJMZK | Original post link

Deleting data will also be restored.

| username: WalterWj | Original post link

Is it possible that the client has turned off auto commit and hasn’t actually committed?

| username: Running | Original post link

Manually execute COMMIT.

| username: TiDBer_pkQ5q1l0 | Original post link

Try executing it through the MySQL client.

| username: 裤衩儿飞上天 | Original post link

  1. Is this root user the superuser root in the database, or is it a business user also named root?
  2. What permissions does this root user have?
  3. Check if the autocommit for this user is turned off?
| username: tidb菜鸟一只 | Original post link

SHOW VARIABLES LIKE ‘%autocommit%’; Take a look.