Can't add mysql database - doesnt show

[jeroman8]

Now any account on the server can add mysql databases.
When adding in cpanel it say: databasexxx added.
But then when going back there's no database !?

I have upcp --force, restarted mysql, changed mysql root pass, rebooted server,
run fixmysql, run mysqlupdate from scripts - nothing helps.

Anyone ?

[jeroman8]

Hu..no one else has/have had this problem ?

cPanel is looking in to though and I will post the fix here in case somone needs
it in the future.

[ret]

I am having the same issue it seems.

However when I attempt to restart mysql it hangs. Note the box runs more than one instant of the script. Are they clashing with eachother?

When I attempt to reset the root passwd through WHM it opens a few instants of the same set of scripts and changes the password over and over to random values. Seems they are conflectiong with eachother.

As a quick fix to get mysql backup I had to schg the .my.cnf file to pervent cpanel from changing what it thought the password should be. I then set it manualy in .my.cnf and the mysqld with skip-grant-tables so that they would sync. Next I took away mysql rights from chkservd.

Not receaving anything useful from err log, just starts and stops. "" in .my.cnf is not the issue. This is only affecting one server and I'm at a loss.

[ret]

Hello,

I'm still having this issue. Currently I am unable to change mysql password through cpanel w/o it scrolling through a number of the same scripts always leading to an eventual timeout of the change password script ending with out of sync passwords and the like. After killing all rogue processes and getting mysql up by hand user are no longer able to create databases even though the .my.cnf and mysql passwords are in sysnc.

Does anyone have any insight on this issue as it has just occured on a second server. Thanks in advance for any assistance.

[ret]

Hello,

/etc/rc.d/init.d/chkservd stop
/etc/rc.d/init.d/mysql stop

When attempting a Reset Mysql password reset via cpanel

Mysql password change failed!!
A forced reset will now be attempted.
Reset Mysql Password

Waiting for mysql to restart...../usr/local/libexec/mysqld: ready for connection
s.
Version: '4.0.15' socket: '/tmp/mysql.sock' port: 3306
Done
Changing Password....Done
Reloading Mysqld...
Done
Waiting for mysql to terminate.....
Attempting to restart mysql

bash-2.05b# ps auwx | grep mysql
mysql 78036 2.6 2.1 52376 21516 ?? S 1:18PM 0:00.31 /usr/local/libexec/mysqld -u mysql --datadir /var/db/mysql --skip-grant-tables
root 77525 0.0 0.0 0 0 ?? Z 1:17PM 0:00.00 (mysql)
root 77733 0.0 0.0 0 0 ?? Z 1:17PM 0:00.00 (mysql)
root 77979 0.0 0.0 0 0 ?? Z 1:18PM 0:00.00 (mysql)
root 77314 0.0 1.1 12108 11580 ?? I 1:16PM 0:00.09 /usr/local/cpanel/whostmgr/bin/whostmgr ./passwdmysql
root 77416 0.0 0.2 2972 2464 ?? I 1:17PM 0:00.06 /usr/bin/perl /scripts/restartsrv2 mysql
root 77522 0.0 0.3 3544 3000 ?? I 1:17PM 0:00.05 /usr/bin/perl /scripts/restartsrv_mysql --check
root 77524 0.0 0.2 2980 2536 ?? I 1:17PM 0:00.05 /usr/bin/perl /scripts/mysqlconnectioncheck
root 77526 0.0 1.1 12088 11564 ?? I 1:17PM 0:00.08 /usr/local/cpanel/whostmgr/bin/whostmgr doresetmysqlroot
root 77639 0.0 0.2 2968 2460 ?? I 1:17PM 0:00.06 /usr/bin/perl /scripts/restartsrv2 mysql
root 77731 0.0 0.3 3544 3000 ?? I 1:17PM 0:00.05 /usr/bin/perl /scripts/restartsrv_mysql --check
root 77732 0.0 0.2 2980 2536 ?? I 1:17PM 0:00.05 /usr/bin/perl /scripts/mysqlconnectioncheck
root 77734 0.0 1.1 12088 11564 ?? I 1:17PM 0:00.09 /usr/local/cpanel/whostmgr/bin/whostmgr doresetmysqlroot
root 77856 0.0 0.2 2968 2460 ?? S 1:18PM 0:00.06 /usr/bin/perl /scripts/restartsrv2 mysql
root 77976 0.0 0.3 3544 3000 ?? S 1:18PM 0:00.05 /usr/bin/perl /scripts/restartsrv_mysql --check
root 77977 0.0 0.2 2980 2544 ?? S 1:18PM 0:00.05 /usr/bin/perl /scripts/mysqlconnectioncheck
root 77980 0.0 1.1 12088 11584 ?? S 1:18PM 0:00.10 /usr/local/cpanel/whostmgr/bin/whostmgr doresetmysqlroot
root 78035 0.0 1.1 12088 11584 ?? S 1:18PM 0:00.00 /usr/local/cpanel/whostmgr/bin/whostmgr doresetmysqlroot
root 78066 0.0 1.1 12088 11584 ?? S 1:18PM 0:00.00 /usr/local/cpanel/whostmgr/bin/whostmgr doresetmysqlroot

This occures for 10 plus mins during which time the passwords in /root/.my.cnf change ever min or so.

It seems as if the reset script is starting the mysql server w/o grant's to change the password before it changes it to what I provided one of the scripts starts to do the same thing. Is it possible that they are walking on eachother causeing this issue.

During all of this the .err log only shows normal starts and stops as the server continues on its crack binge.

Just to get mysql up and running again I'm required to kill all existing perl/mysqlstuff proccess and reset password by hand.
mysqld_safe --skip-grant-tables -u root &
mysqladmin -u root flush-privileges password mysqlpass

Similar issues occure while trying to restart mysql as well at this point.