Make Mysql Server Has Write Permissions In The \xampp\tmp Folder
how can i change the privilege of the directory \xampp\tmp in Mysql Server into write coz when i want to create and write in a csv file with the query bellow , i'm facing this err
Solution 1:
Set writable permissions for /xampp/tmp (unix):
sudo chmod 777 /xampp/tmpWindows:
1. Right-click the file or folder, click Properties, andthen click the Security tab. 2. Click Advanced, andthen click the Owner tab. 3. Click Edit, andthendo one of the following: · To change the owner to a user orgroup that isnot listed, click Other users and groups and, in Enter the object name toselect (examples), type the name of the user orgroup, andthen click OK. · To change the owner to a user orgroup that is listed, in the Change owner to box, click the new owner. 4. If you want totake ownership of the contents of the folder, select the Replace owner onsub containers and objects check box. 5. Click OK, andthen click Yes when you receive the following message: · You donot 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 totake ownership of. 6. Click OK, andthen 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.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'
Post a Comment for "Make Mysql Server Has Write Permissions In The \xampp\tmp Folder"