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 troubles after update to latest version WHM/CPANEL

Discussion in 'Database Discussion' started by dimm, Aug 25, 2005.

  1. dimm

    dimm Registered

    Aug 20, 2005
    Likes Received:
    Trophy Points:
    After I have updated WHM/CPANEL to 10.6.0 version (R55) - following
    problem has arised:

    MySQL restarting every 8 minutes by the script called restartsrv_mysql.
    looks like that mysqlconnection script is not being seen by MySQL...

    Originally, the pid-file called, after a restart
    there is another pid file being created, called

    Here's the order of how its being processed:

    /usr/bin/perl /scripts/restartsrv_mysql --check
    /usr/bin/perl /scripts/mysqlconnectioncheck
    /usr/local/cpanel/whostmgr/bin/whostmgr doresetmysqlroot

    The mysql root password is being changed...

    shell> mysql -uroot -password gives an error:
    ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

    mysql socket - /tmp/mysql.sock

    Here's its symlinks:

    Directory /tmp has following access rights:
    drwxrwxrwt 13 root wheel 13312 Aug 24 09:23 tmp

    Mysql socket has following access rights:
    srwxrwxrwx 1 mysql wheel 0 Aug 24 09:20 mysql.sock

    /etc/my.cnf contains the following:
    set-variable = max_connections=500

    If we would reset root password for mysql via WHM/CPANEL and
    stop the CPANEL - manually restart MYSQL - then this problem
    does not appear...

    shell> mysql -uroot -ppassword - processed with no errors

    Software version:
    MySQL 4.0.22, FreeBSD 4.9-RELEASE, WHM 10.6.0 cPanel 10.6.0-R55

    How do I stop mysql from restarting and flushing the root password ?

    I appreciate any help on this. Thank You.

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