使MySQL服务器在\ xampp \ tmp文件夹中具有写权限 [英] make MySQL server has write permissions in the \xampp\tmp folder

问题描述

如何将Mysql Server中\ xampp \ tmp目录的特权更改为写入

how can i change the privilege of the directory \xampp\tmp in Mysql Server into write

coz当我想使用查询波纹管在csv文件中创建和写入时，我在mysql中遇到此错误msg(无法创建/写入文件'\ tmp \ orders.csv'(错误代码:2 ))

coz when i want to create and write in a csv file with the query bellow , i'm facing this error msg in mysql (Can't create/write to file '\tmp\orders.csv' (Errcode: 2))

查询:

SELECT g.id, g.name, g.date, g.date_mod, g.status, cree_par, modifier_par
FROM glpi_tickets g , (select id, concat(realname , ' ' , firstname)
cree_par from glpi_users ) c, (select id, concat(realname , ' ' ,
firstname) modifier_par from glpi_users) m
where users_id_recipient <> users_id_lastupdater
and users_id_recipient = c.id
and users_id_lastupdater = m.id 
INTO OUTFILE '/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

提前感谢^^

推荐答案

1. 设置/xampp/tmp(unix)的可写权限:

1. Set writable permissions for /xampp/tmp (unix):

sudo chmod 777 /xampp/tmp

Windows:

1. Right-click the file or folder, click Properties, and then click the Security tab.
2. Click Advanced, and then click the Owner tab.
3. Click Edit, and then do one of the following:
   · To change the owner to a user or group that is not listed, click Other users and groups and, in Enter the object name to select (examples), type the name of the user or group, and then click OK.
   · To change the owner to a user or group that is listed, in the Change owner to box, click the new owner.
4. If you want to take ownership of the contents of the folder, select the Replace owner on sub containers and objects check box.
5. Click OK, and then click Yes when you receive the following message:
    · You do not have permission to read the contents of directory folder name. Do you want to replace the directory permissions with permissions granting you Full Control?
    · All permissions will be replaced if you click Yes.
Note folder name is the name of the folder that you want to take ownership of.
6. Click OK, and then reapply the permissions and security settings that you want for the folder and its contents.
   Additional considerations
    · An administrator can take ownership of any file on the computer.
    · Assigning ownership of a file or a folder might require you to elevate your permissions using User Access Control.

设置正确的OUTFILE路径

Set right OUTFILE path

SELECT g.id, g.name, g.date, g.date_mod, g.status, cree_par, modifier_par
FROM glpi_tickets g , (select id, concat(realname , ' ' , firstname)
cree_par from glpi_users ) c, (select id, concat(realname , ' ' ,
firstname) modifier_par from glpi_users) m
where users_id_recipient <> users_id_lastupdater
and users_id_recipient = c.id
and users_id_lastupdater = m.id 
INTO OUTFILE '/xampp/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'

这篇关于使MySQL服务器在\ xampp \ tmp文件夹中具有写权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！