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.

MySQL - my.cnf empty

Discussion in 'General Discussion' started by Ashi Oni, Jun 13, 2010.

  1. Ashi Oni

    Ashi Oni Member

    Joined:
    Jun 11, 2010
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Howdy:

    I have recently setup a new server and everything seems to be working / running fine, however I'm noticed two issues with MySQL that makes me wonder if I setup something incorrectly...

    First - the my.cnf file is empty! Shouldn't this file contain configuration information related to MySQL?

    Second - I have MySQL 5.1 installed, but CSF is stating I'm running legacy MySQL software and should update it.

    I'm guessing that I did NOT setup something correctly.

    Do you have any ideas to what I might have done incorrectly or overlooked during setup?

    Thanks for your time.
     
  2. Ashi Oni

    Ashi Oni Member

    Joined:
    Jun 11, 2010
    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    1
    Not sure if I just solved my issue or not.

    I went in and wrote out the my.cnf by hand using vi

    Code:
    [mysqld]
    local-infile = 0
    max_connections = 300
    key_buffer = 32M
    myisam_sort_buffer_size = 32M
    join_buffer_size = 1M
    read_buffer_size = 1M
    sort_buffer_size = 2M
    table_cache = 4000
    thread_cache_size = 286
    interactive_timeout = 25
    wait_timeout = 7000
    connect_timeout = 10
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 2M
    query_cache_size = 12M
    query_cache_type = 1
    tmp_table_size = 16M
    skip-innodb
    [mysqld_safe]
    open_files_limit = 8192
    [mysqldump]
    quick
    max_allowed_packet = 16M
    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M
    [mysqlhotcopy]
    interactive-timeout 
    
    I guess I'll run with it unless someone out knows this will become and issue. (security issue, etc)
     
  3. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,481
    Likes Received:
    203
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    Not sure why yours was empty, but the default file is the most basic anyway, so, replacing it with something better can't hurt as long as you're comfortable with those settings. :)
     
Loading...

Share This Page