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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

permission problem since MySQL 5.6.37 update

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

  1. trucmuche

    trucmuche Well-Known Member

    Joined:
    Nov 20, 2014
    Messages:
    80
    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 Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,220
    Likes Received:
    1,376
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

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

    Thank you.
     
  3. trucmuche

    trucmuche Well-Known Member

    Joined:
    Nov 20, 2014
    Messages:
    80
    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.
     
Loading...

Share This Page