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 hostname.full.pid, after a restart
there is another pid file being created, called hostnameshort.pid
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: '[email protected]' (Using password: YES)
mysql socket - /tmp/mysql.sock
Here's its symlinks:
/var/lib/mysql/mysql.sock
/var/db/mysql/mysql.sock
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:
[mysqld]
set-variable = max_connections=500
safe-show-database
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.
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 hostname.full.pid, after a restart
there is another pid file being created, called hostnameshort.pid
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: '[email protected]' (Using password: YES)
mysql socket - /tmp/mysql.sock
Here's its symlinks:
/var/lib/mysql/mysql.sock
/var/db/mysql/mysql.sock
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:
[mysqld]
set-variable = max_connections=500
safe-show-database
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.