mysql - 如何安装或更改 MySQL 以由任何网络用户使用函数 'load_file'？

Question

目标

当前的目标是，将来自任何网络用户的文件附件作为 BLOB 数据插入 MySQL 数据库。这可以来自任何文件夹 - 例如；桌面。

问题

这是唯一的路径 ---C:/ProgramData/MySQL/MySQL Server 8.0/Uploads--- 允许在 MySQL 中使用 load_file() 函数适本地 。如果我尝试在此处使用此路径: ---C:/Users/eduards/Desktop--- 值显示为 null。

工作 MySQL 查询

插入 document_control(文件附件)值 (load_file('C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/test.docx'));

值显示为BLOB

不工作的 MySQL 查询

插入 document_control(文件附件)值 (load_file('C:/Users/eduards/Desktop/test.docx'));

值显示为null

问题

如果我需要卸载 MySQL - 我很乐意这样做。但是，我在哪里可以允许或启用来自任何路径的任何文件附件作为 BLOB 而不是 null 插入 MySQL 数据库？

Answer 1

根据 documentation :

Reads the file and returns the file contents as a string. To use this function, the file must be located on the server host, you must specify the full path name to the file, and you must have the FILE privilege. The file must be readable by the server and its size less than max_allowed_packet bytes. If the secure_file_priv system variable is set to a nonempty directory name, the file to be loaded must be located in that directory. (Prior to MySQL 8.0.17, the file must be readable by all, not just readable by the server.)

If the file does not exist or cannot be read because one of the preceding conditions is not satisfied, the function returns NULL.