【IT专家】MYSQL文件外文件“访问被拒绝”
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
本文由我司收集整编，推荐下载，如有疑问，请与我司联系
MYSQL文件外文件“访问被拒绝”
MYSQL文件外文件“访问被拒绝”-但我的用户有“所有”访问。文件夹是CHMOD 777[英]MYSQL into outfile “access denied” - but my user has “ALL” access.. and the folder is CHMOD 777SELECT * INTO OUTFILE ‘/home/myacnt/docs/mysqlCSVtest.csv’FIELDS TERMINATED BY ‘,’ OPTIONALLY ENCLOSED BY ‘*’LINES TERMINATED BY ‘\n’FROM tbl_property WHERE managerGroupID = {$managerGroupID} Error:
错误:
Access denied for user ‘asdfsdf’@’localhost’ (using password: YES) It seems that you are having issues with connecting to the database and not writing to the folder you’re mentioning.
似乎您在连接数据库时遇到了问题，而没有写入您所提到的文件夹。
Also, make sure you have granted FILE to user ‘asdfsdf’@’localhost’.
另外，确保您已经将文件授予了user ‘asdfsdf’@’localhost’。
GRANT FILE ON *.* TO ‘asdfsdf’@’localhost’; 33
Honestly I didnt bother to deal with the grants and this worked even without the privileges:
坦白说，我并没有费心去处理这些赠款，纵然没有这些特权，我也会这样做:
echo “select * from employee” | mysql --host=HOST --port=PORT --user=UserName --password=Password DATABASE.SCHEMA output.txt 0
Since cP/WHM took away the ability to modify User privileges as root in PHPMyAdmin, you have to use the command line to:
由于cP/WHM剥夺了在PHPMyAdmin中作为根用户修改用户权限的能力，因此必须使用命令行:
mysql GRANT FILE ON *.* TO ‘user’@’localhost’; Step 2 is to allow that user to dump a file in a specific folder. There are a few ways to do this but I ended up putting a