TiDB was working fine, but suddenly I can't create new users anymore

Translated
1

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

Original topic: tidb本来好好的 不知道为何突然无法新建用户了

| username: tidb狂热爱好者

【TiDB Usage Environment】Production Environment or Test Environment or POC
【TiDB Version】6.1
【Encountered Problem】
【Reproduction Path】Just a normal migration of the TiDB database using mysqldump to import and export tables. Everything was normal until suddenly it became impossible to create new users.
【Problem Phenomenon and Impact】
grant usage on . to ‘a’@‘localhost’ identified by ‘123’;
ERROR 1364 (HY000): Field ‘ssl_cipher’ doesn’t have a default value

【Attachments】

Please provide the version information of each component, such as cdc/tikv, which can be obtained by executing cdc version/tikv-server --version.

2
| username: db_user | Original post link

It is estimated that the system database (mysql) structure has changed due to using mysqldump for import.

3
| username: 我是咖啡哥 | Original post link

The system table must have been overwritten. :innocent:

4
| username: h5n1 | Original post link

How long is the GC time? Try flashback.
Flashback dropped table: Flashback table xxx to xxx_bak;
Flashback query: select * from xxx as of timestamp ‘2022-06-28 17:00:00’