Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

permission problem since MySQL 5.6.37 update

Discussion in 'Database Discussion' started by trucmuche, Sep 1, 2017.

  1. trucmuche

    trucmuche Well-Known Member

    Joined:
    Nov 20, 2014
    Messages:
    82
    Likes Received:
    3
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    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.
     
    #1 trucmuche, Sep 1, 2017
    Last edited: Sep 1, 2017
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,198
    Likes Received:
    1,936
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

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

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Sep 1, 2017
  3. trucmuche

    trucmuche Well-Known Member

    Joined:
    Nov 20, 2014
    Messages:
    82
    Likes Received:
    3
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    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.
     
    #3 trucmuche, Sep 1, 2017
  4. JawadArshad

    JawadArshad Well-Known Member
    PartnerNOC

    Joined:
    Apr 8, 2008
    Messages:
    458
    Likes Received:
    6
    Trophy Points:
    68
    Location:
    PK
    cPanel Access Level:
    DataCenter Provider
    Is there any update on this. I am encountering a similar problem.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 JawadArshad, Oct 14, 2017
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,198
    Likes Received:
    1,936
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 cPanelMichael, Oct 27, 2017
(You must log in or sign up to post here.)
Loading...
Similar Threads - permission problem since
  1. Nicola Urbinati

    File permissions problems

    Nicola Urbinati, Nov 6, 2018, in forum: General Discussion
    Replies:
    5
    Views:
    94
    cPanelMichael
    Nov 9, 2018
  2. Christos Liaskonis

    Permission problems in wordpress

    Christos Liaskonis, Oct 28, 2018, in forum: General Discussion
    Replies:
    2
    Views:
    341
    cPanelMichael
    Oct 29, 2018
  3. Tornado

    Permission problem on new server

    Tornado, Oct 17, 2018, in forum: General Discussion
    Replies:
    5
    Views:
    190
    cPanelLauren
    Nov 2, 2018
  4. Brooky A

    WHM API 1 getdiskusage - Permission problem

    Brooky A, Oct 4, 2018, in forum: cPanel Developers
    Replies:
    1
    Views:
    142
    cPanelLauren
    Oct 9, 2018
  5. Mr.Novo

    Subdomain permission problem with upload

    Mr.Novo, Jun 24, 2018, in forum: General Discussion
    Replies:
    5
    Views:
    343
    cPanelLauren
    Jun 28, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice