Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: TIDB循环插入多表,出现授权信息限制,如何解决?
[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?
This error message doesn’t seem to be from the database. Can you share a screenshot?
Where is the error displayed?
Post the error message and let us take a look.
Post a screenshot of the logs and let us take a look.
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.
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.
So it’s a problem with the framework version?
Haven’t encountered this, marking it.