How to Solve Authorization Information Restriction When Inserting into Multiple Tables in a Loop in TiDB?

Translated
1

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

Original topic: TIDB循环插入多表，出现授权信息限制，如何解决？

| username: TiDBer_ydSkDlLw

[TiDB Usage Environment] Production Environment / Testing / PoC
[TiDB Version] V8.0.0
[Reproduction Path]
[Encountered Problem: Problem Phenomenon and Impact] Loop insertion, inserting into 20 tables, each table inserting 200 records, with 32 columns per table. After looping 11-15 times, an error message appears: Authorization information limit, need to increase the basic information database configuration.
The user being used is the root administrator. How to solve the current problem?

QQ Screenshot 20240530153155
QQ Screenshot 202405301531551079×298 7.8 KB

2
| username: MrSylar | Original post link

This error message doesn’t seem to be from the database. Can you share a screenshot?

3
| username: zhanggame1 | Original post link

Where is the error displayed?

4
| username: xfworld | Original post link

Post the error message and let us take a look.

5
| username: 随缘天空 | Original post link

Post a screenshot of the logs and let us take a look.

6
| username: TIDB-Learner | Original post link

Even root can encounter permission issues for certain reasons. It is recommended to check with SHOW GRANTS FOR ‘root’; to see if it is GRANT ALL PRIVILEGES ON . TO ‘root’@‘%’ WITH GRANT OPTION.

7
| username: TiDBer_ydSkDlLw | Original post link

I am using .NET for development, with the framework being .NET 4.5.2 and MySql.DLL version 6. This version prompts this error. Upgrading the framework to a higher version and MySql DLL to version 8 resolves the issue. Please pay attention to this problem. Thank you all for your support.

8
| username: MrSylar | Original post link

So it’s a problem with the framework version?

9
| username: 濱崎悟空 | Original post link

Haven’t encountered this, marking it.