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!

Cannot locate my.cnf

Discussion in 'Database Discussion' started by RomainB, Aug 25, 2016.

Tags:
  1. RomainB

    RomainB Member

    Joined:
    Dec 15, 2007
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    51
    Hello

    I need to do some modifications of Mysql's configurations but I cannot locate my.cnf file.

    Do you know how to find it ?

    My server : CentOs 7

    Thank you
     
    #1 RomainB, Aug 25, 2016
  2. SysSachin

    SysSachin Well-Known Member

    Joined:
    Aug 23, 2015
    Messages:
    604
    Likes Received:
    43
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    By default you’ll find MySQL’s configuration file at: /etc/my.cnf
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 SysSachin, Aug 25, 2016
  3. RomainB

    RomainB Member

    Joined:
    Dec 15, 2007
    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    51
    The file is not there.

    vi /etc/my.cnf : The system asks me to create a file with this name...
     
    #3 RomainB, Aug 25, 2016
  4. SysSachin

    SysSachin Well-Known Member

    Joined:
    Aug 23, 2015
    Messages:
    604
    Likes Received:
    43
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hi,

    Please check MySQL’s configuration file at /etc/mysql/my.cnf

    If not found then run below command to find my.cnf file
    Code:
    whereis my.cnf
    or
    find / -name my.cnf
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 SysSachin, Aug 25, 2016
  5. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

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

    Could you verify if you are logged in via SSH as the "root" user? You can only edit the MySQL configuration with root access to the system.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 cPanelMichael, Aug 25, 2016
(You must log in or sign up to post here.)
Loading...
Similar Threads - Cannot locate
  1. mahlah207

    Can't fork: Cannot allocate memory

    mahlah207, Oct 16, 2017, in forum: General Discussion
    Replies:
    3
    Views:
    1,060
    cPWilliamL
    Oct 17, 2017
  2. Havri

    git pull Cannot allocate memory

    Havri, Jun 7, 2017, in forum: General Discussion
    Replies:
    3
    Views:
    801
    Havri
    Jun 7, 2017
  3. zefie

    Cannot reboot through WHM

    zefie, Dec 10, 2018 at 5:11 AM, in forum: General Discussion
    Replies:
    3
    Views:
    167
    cPanelLauren
    Dec 12, 2018 at 12:13 PM
  4. VM Creativo

    Users cannot use WP-CLI in cron

    VM Creativo, Dec 8, 2018, in forum: General Discussion
    Replies:
    2
    Views:
    121
    cPanelLauren
    Dec 11, 2018 at 8:08 AM
  5. Cristian Samuel Vargas

    Cannot Email PDF Files

    Cristian Samuel Vargas, Dec 6, 2018, in forum: E-mail Discussion
    Replies:
    6
    Views:
    450
    cPanelMichael
    Dec 13, 2018 at 1:26 PM

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