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.

Cannot locate my.cnf

Discussion in 'Database Discussions' 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:
    562
    Likes Received:
    40
    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
     
    #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:
    562
    Likes Received:
    40
    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
     
    #4 SysSachin, Aug 25, 2016
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,165
    Likes Received:
    1,371
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    #5 cPanelMichael, Aug 25, 2016
(You must log in or sign up to post here.)
Loading...
Similar Threads - Cannot locate
  1. Havri

    git pull Cannot allocate memory

    Havri, Jun 7, 2017, in forum: General Discussion
    Replies:
    3
    Views:
    164
    Havri
    Jun 7, 2017
  2. Art Shotwell

    Cannot allocate memory

    Art Shotwell, Oct 15, 2016, in forum: Workarounds and Optimization
    Replies:
    3
    Views:
    782
    cPanelMichael
    Oct 24, 2016
  3. calamus

    Dovecot - Cannot allocate memory

    calamus, Aug 4, 2016, in forum: E-mail Discussions
    Replies:
    4
    Views:
    1,961
    cPanelMichael
    Aug 8, 2016
  4. Jose Negron

    Inernal Server Error 500 Cannot allocate memeory

    Jose Negron, Apr 18, 2016, in forum: General Discussion
    Replies:
    1
    Views:
    789
    cPanelMichael
    Apr 18, 2016
  5. Mark.pluto3

    Website DNS cannot be found

    Mark.pluto3, Sep 14, 2017, in forum: Bind / DNS / Nameserver Issues
    Replies:
    1
    Views:
    61
    cPanelMichael
    Sep 14, 2017

Share This Page