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!

Mysql Log

Discussion in 'General Discussion' started by aswin, Sep 19, 2009.

  1. aswin

    aswin Registered

    Joined:
    Sep 19, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    51
    Hi
    I have a cpanel server with CentOS 5.3-32 and mysql version 5.0.81.. I need to enable mysql general and access log" Found some commands to do this on internet and checked but it didnt work.I had tried adiing these entries to /etc/my.cnf
    err-log=/var/log/mysqld.log
    /var/log/mysqldquery.log
    and restarted mysql but no luck.I have also tried to enable log on runtime by this command
    " "SET GLOBAL general_log = 'ON';
    but it shows an error message " ERROR 1193 (HY000): Unknown system variable 'general_log' "
    is there any solution to this
    :)
     
  2. thewebhosting

    thewebhosting Well-Known Member

    Joined:
    May 9, 2008
    Messages:
    1,201
    Likes Received:
    1
    Trophy Points:
    68
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. aswin

    aswin Registered

    Joined:
    Sep 19, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    51
    Thanks :) But is there anyway to enable this log on the current mysql version on my server through WHM? Since this is a live server, i cannot afford to upgrade the mysql, as it may cause a downtime of my sites. Is there any other way to enable the logs... Help is really appreciated;
     
Loading...

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.
    Dismiss Notice