Consider that local disk files are accessible via MySQL with commands such as:
mysql> LOAD DATA LOCAL INFILE ‘/etc/passwd’ INTO TABLE mypasswords;
What change could be made to stop any breach via this insecurity?
A. executing REVOKE LOAD FROM .
B. setting the —local-service=0 option when starting mysqld
C. executing REVOKE FILE FROM _
D. executing REVOKE FILE ON _ FROM ‘ ‘@’%’
E. setting the —local-infile=0 option when starting mysqld
F. setting the —open-files-limit=0 option when starting mysqld
Answer: E
对于MySQL客户端本地数据加载默认是禁用的。禁用或启用它明确,使用—local-infile=0或—local-infile[=1]选项
对于mysqlimport客户端本地数据加载默认是禁用的。禁用或启用它明确,使用—local=0或—local[=1]选项
版权声明:本文为博主原创文章,未经博主允许不得转载。
MYSQL
- 上一篇:Mysql OCP 20题
- 下一篇:Mysql OCP 22题



