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

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?

| username: MrSylar | Original post link

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

| username: zhanggame1 | Original post link

Where is the error displayed?

| username: xfworld | Original post link

Post the error message and let us take a look.

| username: 随缘天空 | Original post link

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

| 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.

| 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.

| username: MrSylar | Original post link

So it’s a problem with the framework version?

| username: 濱崎悟空 | Original post link

Haven’t encountered this, marking it.