Exporting TiDB User Accounts

Translated
1

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

Original topic: tidb用户账号导出

| username: zhujunhui

[TiDB Usage Environment] Production
[TiDB Version] 6.1, 4.1
[Encountered Issue] Synchronizing user accounts from 4.1 to 6.1 cluster

2
| username: ddhe9527 | Original post link

Synchronization can only be done logically. Account data can be roughly considered as static data. If you have a visual tool like Navicat, you can export it as INSERT statements and import it directly.

3
| username: 啦啦啦啦啦 | Original post link

The simplest way is to write a script to batch show create user and show grants, then import the results. Alternatively, you can use dumpling to export and import logically.

4
| username: zhujunhui | Original post link

Yes, synchronized in this way.

5
| username: zhujunhui | Original post link

Let me ask again, the mem-quota-query configuration file is not effective under 6.1. Has the file configuration been canceled?

6
| username: system | Original post link

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