sql - make MySQL server has write permissions in the \xampp\tmp folder -

how can change privilege of directory \xampp\tmp in mysql server write

coz when want create , write in csv file query bellow , i'm facing error msg in mysql (can't create/write file '\tmp\orders.csv' (errcode: 2))

the query :

select g.id, g.name, g.date, g.date_mod, g.status, cree_par, modifier_par glpi_tickets g , (select id, concat(realname , ' ' , firstname) cree_par glpi_users ) c, (select id, concat(realname , ' ' , firstname) modifier_par glpi_users) m users_id_recipient <> users_id_lastupdater , users_id_recipient = c.id , users_id_lastupdater = m.id  outfile '/tmp/orders.csv' fields terminated ',' enclosed '"' lines terminated '\n' 

thanks in advance ^^

1. set writable permissions /xampp/tmp (unix):

   sudo chmod 777 /xampp/tmp 

   windows:

   1. right-click file or folder, click properties, , click security tab. 2. click advanced, , click owner tab. 3. click edit, , 1 of following:    · change owner user or group not listed, click other users , groups and, in enter object name select (examples), type name of user or group, , click ok.    · change owner user or group listed, in change owner box, click new owner. 4. if want take ownership of contents of folder, select replace owner on sub containers , objects check box. 5. click ok, , click yes when receive following message:     · not have permission read contents of directory folder name. want replace directory permissions permissions granting full control?     · permissions replaced if click yes. note folder name name of folder want take ownership of. 6. click ok, , reapply permissions , security settings want folder , contents.    additional considerations     · administrator can take ownership of file on computer.     · assigning ownership of file or folder might require elevate permissions using user access control. 

2. set right outfile path

   select g.id, g.name, g.date, g.date_mod, g.status, cree_par, modifier_par glpi_tickets g , (select id, concat(realname , ' ' , firstname) cree_par glpi_users ) c, (select id, concat(realname , ' ' , firstname) modifier_par glpi_users) m users_id_recipient <> users_id_lastupdater , users_id_recipient = c.id , users_id_lastupdater = m.id  outfile '/xampp/tmp/orders.csv' fields terminated ',' enclosed '"' lines terminated '\n'