About the execution of load_file () as NULL? in mysql

when learning the knowledge of mysql penetration, the attempt to read the file on disk D with sql statement failed as follows:

clipboard.png

root@host

after testing, the value of secure-file-priv is not valid even if it is empty.

mysql,apache is running normally

I really can"t find the point of the problem

What does the

document mean that the file must be on the server? does it mean on your own computer?

I am a rookie, asking for advice

Mar.02,2021

resolved: reference article
https://blog.csdn.net/qq47317.

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e885ba-ed1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e885ba-ed1.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?