permission problem since MySQL 5.6.37 update

trucmuche

• September 01, 2017 03:16

Hello, I was running MySQL 5.5 and I was able to export results of MySQL queries into a file using "INTO OUTFILE". Everything was fine. Then I updated to MySQL 5.6 last days (for some reasons) and now, when I run the same queries, it gives me the error : "Can't create/write to file '/home/account/dir/dir2/filename.csv' (Errcode: 13 - Permission denied)". I tried using "INTO OUTFILE 'filename.csv'" instead of "INTO OUTFILE '/home/account/dir/dir2/filename.csv'" and it worked ! But I can't understand the problem since dir2 has 777 permissions... What's the problem now ?? Why MySQL is unable to write this file ?? Thanks in advance for your help, T.

• 

  cPanelMichael

  • September 01, 2017 15:10

  Hello, Could you open a support ticket using the link in my signature so we can take a closer look? Thank you.

  0
• 

  trucmuche

  • September 01, 2017 17:00

  Thank you @cPanelMichael ! It's done. This is the first time I do it so I hope that everything is ok. Support request ID is #8834491.

  0
• 

  JawadArshad

  • October 14, 2017 21:17

  Is there any update on this. I am encountering a similar problem.

  0
• 

  cPanelMichael

  • October 27, 2017 16:44

  Is there any update on this. I am encountering a similar problem.

  
  The original poster's issue related to the permissions on the directory associated with the running script. It was set to 0750 instead of 0755. Updating the directory permissions to 0755 solved the issue. Thank you.

  0

Please sign in to leave a comment.