MySQL error:the used command isn't allowed with this MySQL version workaround

Purpose: To import a. txt file to the MySQL database, using the load command to implement

Enter the following command to error:

Modify the command, still error:

Possible causes (from MySQL reference manual):

If LOAD DATA localis Disabled, either in the server or the client, a client that attempts to issue such a statement receiv Es the fol-lowing error message:

ERROR 1148:the used command isn't allowed with this MySQL versionvisible, for security reasons, the default is not to allow remote access via the load Data command from client host Workaround:

When logging in to MySQL, you need to explicitly specify parameters with--local-infile[=1]

Problem solving

MySQL error:the used command is a allowed with this MySQL version workaround