Examveda
Examveda

The LOCAL capability for client library is enabled by . . . . . . . .

A. -enabled-local-file

B. -enable-local-infile

C. -enable-global-file

D. -enable-local-file

Answer: Option B

Solution(By Examveda Team)

-enable-local-infile: This option enables the capability to load data from local files using the client library. It allows MySQL client programs to read data files from the client host rather than the server host. Enabling this option allows the use of the LOAD DATA LOCAL INFILE statement to load data from local files into database tables. It is a security feature that can be controlled by server administrators.
-enabled-local-file: This option does not exist in MySQL. It is not a valid option for enabling the LOCAL capability for the client library.
-enable-global-file: This option is incorrect. There is no option named -enable-global-file in MySQL for enabling the LOCAL capability for the client library.
-enable-local-file: This option is similar to the correct option, but the correct option is -enable-local-infile.

Therefore, the correct option for enabling the LOCAL capability for the client library is Option B: -enable-local-infile.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous