在PHPmyadmin中加载数据文件 [英] LOAD DATA INFILE within PHPmyadmin

问题描述

我正在PHPmyadmin中运行以下命令:

I'm running the following command within PHPmyadmin:

LOAD DATA INFILE '/test3.csv' INTO TABLE temp_car FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES (recloc,divdept)

AND

LOAD DATA INFILE '/var/www/vhosts/domain.com/httpdocs/admin/server/test3.csv' INTO TABLE temp_car FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 LINES (recloc,divdept)

我收到此错误:

#1045 - Access denied for user 'db_admin'@'%' (using password: YES) 

我尝试将文件的权限更改为777，将包含文件夹的权限更改为777.

I've tried changing the permissions to the file to 777 and the containing folder to 777.

有什么想法吗?我在使用LOAD DATA INFILE进行工作测试时经历了可怕的时光

Any ideas? I'm having a terrible time getting a working test with LOAD DATA INFILE

推荐答案

这篇关于在PHPmyadmin中加载数据文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！