Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.
Original topic: The used command is not allowed with this MySQL version
[TiDB Usage Environment] Development / Testing / PoC
[TiDB Version] 6.1.1
[Encountered Problem]
The used command is not allowed with this MySQL version, Note: local_infile=ON
[Reproduction Path] Operations performed that led to the problem
Using LOAD DATA LOCAL INFILE ‘xxx…’, an error occurs
[Problem Phenomenon and Impact]
[Attachments]
I have seen this, but the visualization tool cannot add --parameter commands!
Is it necessary to use visualization tools? You can try xshell, crt, etc. If you’re on Windows, you can also use the cmd command prompt directly.
The code also reports an error, the same error as the tool! Even if I use the command line to execute with the startup command and it doesn’t report an error, I still need to handle it in the code, and it will also need to be added when going live. This is unreasonable, and I even suspect it might be a TiDB version issue!
@TiDBer_rRaLYPCO After adding --local-infile=1 as suggested above, did you encounter any new errors? Could you provide a test screenshot and the error message?
I found that this issue does not occur with the lower version of the database driver (5.1.46) and you need to specify the driver class without “cj”. Using the 8.x driver will result in an error. I don’t know the reason, but I hope the official team can see this post and fix it!
This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.
|
username: TiDBer_rRaLYPCO
|
username: 
|
username: 
|
username: