MySQL LOAD_FILE（）加载空值

确保：

• 在父目录上有执行权限
• 必须明确授予FILE特权。（上获得文件 。 对用户@本地）
• 您拥有冲洗权限
• 您已注销并重新登录

父目录权限的示例：

mysql> ！ls -ld`dirname / home / jlam / pre / projectName / doc / filesForTesting / images / imageTest01.jpg`drwxrwxr--。2 jlam jlam 4096 5月12日14:22 / home / jlam / pre / projectName / doc / filesForTesting / imagesmysql>选择十六进制（LOAD_FILE（'/ home / jlam / pre / projectName / doc / filesForTesting / images / imageTest01.jpg'））;+ ------------------------------------------------- -------------------------------------------------- ---------- +| 十六进制（LOAD_FILE（'/ home / jlam / pre / projectName / doc / filesForTesting / images / imageTest01.jpg'））|+ ------------------------------------------------- -------------------------------------------------- ---------- +| NULL |+ ------------------------------------------------- -------------------------------------------------- ---------- +设置1行（0.00秒）mysql> ！chmod o + x / home / jlam / pre / projectName / doc / filesForTesting / imagesmysql> ！ls -ld`dirname / home / jlam / pre / projectName / doc / filesForTesting / images / imageTest01.jpg`drwxrwxr-x。2 jlam jlam 4096 5月12日14:22 / home / jlam / pre / projectName / doc / filesForTesting / imagesmysql>选择十六进制（LOAD_FILE（'/ home / jlam / pre / projectName / doc / filesForTesting / images / imageTest01.jpg'））;+ ------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------| 十六进制（LOAD_FILE（'/ home / jlam / pre / projectName / doc / filesForTesting / images / imageTest01.jpg'））       + ------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------| FFD8FFE1001845786966000049492A00080000000000000000000000FFEC00114475636B7900010004000000500000FFE10407687474703A2F2F6E732E61646F62652E636F6D2F786​​1702F312E302F003C3F787​​061636B657420626567696E3D22EFBBBF222069643D2257354869+ ------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------

用户权限示例：

16:38:09（getImages）〜/ pre / projectName / doc / filesForTesting / images $ mysql -u eventCal -p eventCal输入密码：mysql>显示授权；+ ------------------------------------------------- -------------------------------------------------- -------------- +| 授予eventCal @ localhost |+ ------------------------------------------------- -------------------------------------------------- -------------- +| *。*对'eventCal'@'localhost'的授权使用已由密码'* xxxx'标识|| 将所有特权授予tmp。*至'eventCal'@'localhost'|| 将所有特权授予`eventCalTesting`。*到'eventCal'@'localhost'|| 将所有特权授予`eventCal`。*到'eventCal'@'localhost'|| 将所有特权授予`eventCal_categoryMigration`。*至'eventCal'@'localhost'|+ ------------------------------------------------- -------------------------------------------------- -------------- +设置5行（0.00秒）mysql>选择十六进制（LOAD_FILE（'/ home / jlam / pre / projectName / doc / filesForTesting / images / imageTest01.jpg'））;+ ------------------------------------------------- -------------------------------------------------- ---------- +| 十六进制（LOAD_FILE（'/ home / jlam / pre / projectName / doc / filesForTesting / images / imageTest01.jpg'））|+ ------------------------------------------------- -------------------------------------------------- ---------- +| NULL |+ ------------------------------------------------- -------------------------------------------------- ---------- +设置1行（0.00秒）

在其他根会话中：

mysql>将文件ON *。*授予eventCal @ localhost;查询正常，受影响的0行（0.00秒）mysql>刷新权限；查询正常，受影响的0行（0.00秒）

在用户会话中，我仍然无法加载文件

mysql>选择十六进制（LOAD_FILE（'/ home / jlam / pre / projectName / doc / filesForTesting / images / imageTest01.jpg'））;+ ------------------------------------------------- -------------------------------------------------- ---------- +| 十六进制（LOAD_FILE（'/ home / jlam / pre / projectName / doc / filesForTesting / images / imageTest01.jpg'））|+ ------------------------------------------------- -------------------------------------------------- ---------- +| NULL |+ ------------------------------------------------- -------------------------------------------------- ---------- +设置1行（0.00秒）

.....但是如果我注销并重新登录：

mysql>退出再见16:40:14（getImages）〜/ pre / projectName / doc / filesForTesting / images $ mysql -u eventCal -p eventCal输入密码：mysql>选择十六进制（LOAD_FILE（'/ home / jlam / pre / projectName / doc / filesForTesting / images / imageTest01.jpg'））;+ ------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------| 十六进制（LOAD_FILE（'/ home / jlam / pre / projectName / doc / filesForTesting / images / imageTest01.jpg'））       + ------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------| FFD8FFE1001845786966000049492A00080000000000000000000000FFEC00114475636B7900010004000000500000FFE10407687474703A2F2F6E732E61646F62652E636F6D2F786​​1702F312E302F003C3F787​​061636B657420626567696E3D22EFBBBF222069643D2257354869+ ------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------------------- -------------------------------------