Question

The security option in MySQL, that when enabled, limits where a file can be loaded from when using the LOAD DATA INFILE command is called:

(a) secure_file_location
(b) secure_file_priv
(c) safe_file_load
(d) safe_file_location

Answer 1

Answer:b) secure_file_priv

Explanation: MYSQL database is the SQL data collection where the command LOAD DATA INFILE is used for the transporting the data-file from the local server to the MYSQL server. This command helps the reading the file's data or text of the client server at rapid speed

The secure_file_priv is the option that is raised from the LOAD DATA INFILE for the limited loading of files from the directories and also makes it secure. Other options are incorrect because they are used for the location and loading.Thus the correct option is option(b).