#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2011
    Posts
    14
    Rep Power
    0

    My.cnf file missing and cannot be found at any directory


    I recently removed mysql 5.1 an installed mysql 5.6 on my CENTOS 6 x86 OS. When I try to look for the my.cnf file it is missing from these directories:

    mysqld --verbose --help | grep -A 1 "Default options"

    =

    /etc/my.cnf, /etc/mysql/my.cnf, and ~/.my.cnf.

    Now I went to my mysql home directory which is /var/lib/mysql to find the .cnf file but all I found was auto.cnf.

    Does anyone have any ideas? Could I just download a my.cnf file and place it in one of those directories?
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2012
    Posts
    2
    Rep Power
    0

    Smile


    It's nothing you worried about. Just create a file my.cnf and put it in /etc.
    File may contains:
    Code:
    [mysqld] 
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    user=mysql 
    old_passwords=1
    [mysqld_safe]
    log-error=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid
    And how you updated mysql. Through source? Updating with yum backs up current setting, for example my.cnf becomes my.cnf.rpmsave or something like this.

IMN logo majestic logo threadwatch logo seochat tools logo