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

Discussion in 'Database Discussions' 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