How do I enable local data Infile?

How do I connect to the local Infile system variable?

To cause the server to permit access, set the local_infile variable with SET GLOBAL local_infile = 1; or check it with SHOW GLOBAL VARIABLES LIKE 'local_infile'; . Alternatively, edit mysql's config to include local_infile=1 . Show activity on this post.

What is local Infile?

In contrast, when you execute the LOAD DATA LOCAL INFILE statement, the client attempts to read the input file from its file system, and it sends the contents of the input file to the MariaDB Server. This allows you to load files from the client's local file system into the database.

How do you solve error 3948 42000 ): loading local data is disabled This must be enabled on both the client and server sides?

“ERROR 3948 (42000) at line 1: Loading local data is disabled; this must be enabled on both the client and server sides” Code Answer's1#set the global variables by using this command:2mysql> SET GLOBAL local_infile=1;3Query OK, 0 rows affected (0.00 sec)4​5#exit current server:6mysql> exit.7​

What is load data local infile?

The LOAD DATA INFILE statement reads rows from a text file into a table at a very high speed. If the LOCAL keyword is specified, the file is read from the client host. If LOCAL is not specified, the file must be located on the server.