MySQL databases missing but they exist in phpadmin

postcd

Well-Known Member
Oct 22, 2010
717
19
68
Hello,

I found today that in cpanel i no longer can se emy mysql databases in databases section, but they do exist in phpmyadmin, i did not deleted them.

in cpanel error log is:
Code:
[2014-11-15 16:13:40 +0000] info [cpses_tool] MYSQL: Remove dbuser cpses_reC18qF1u9 for owner recenze on 107.*.*.*
[2014-11-15 16:13:55 +0000] warn [cpses_tool] The user “recenze” is not authorized to access “cpses_reGmRPM2kn” for revoking permissions from all. at /usr/local/cpanel/Cpanel/DBAdmin.pm line 160
	Cpanel::DBAdmin::_log_error_and_output_return(Cpanel::Mysql=HASH(0x2278e48), 'The user \xE2\x80\x9C[_1]\xE2\x80\x9D is not authorized to access \xE2\x80\x9C[_2]\xE2\x80\x9D for revoking permissions from all.', 'recenze', 'cpses_reGmRPM2kn') called at /usr/local/cpanel/Cpanel/DBAdmin.pm line 177
	Cpanel::DBAdmin::_log_error_and_output(Cpanel::Mysql=HASH(0x2278e48), 'The user \xE2\x80\x9C[_1]\xE2\x80\x9D is not authorized to access \xE2\x80\x9C[_2]\xE2\x80\x9D for revoking permissions from all.', 'recenze', 'cpses_reGmRPM2kn') called at /usr/local/cpanel/Cpanel/Mysql.pm line 501
	Cpanel::Mysql::_dbowner_to_all_with_ownership_checks(Cpanel::Mysql=HASH(0x2278e48), 'method', 'REVOKE', 'users', HASH(0x2279640)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 465
	Cpanel::Mysql::remove_dbowner_from_all(Cpanel::Mysql=HASH(0x2278e48), 'cpses_reGmRPM2kn') called at bin/cpses_tool.pl line 139
	bin::cpses_tool::__ANON__() called at bin/cpses_tool.pl line 155
	bin::cpses_tool::action_REMOVETEMPDBOWNER('bin::cpses_tool', HASH(0x2274078)) called at bin/cpses_tool.pl line 64
	bin::cpses_tool::process_request(HASH(0x2274078)) called at bin/cpses_tool.pl line 51
	bin::cpses_tool::script('bin::cpses_tool') called at bin/cpses_tool.pl line 27
[2014-11-15 16:13:55 +0000] warn [cpses_tool] The cPanel user “recenze” is not allowed to grant access to any of the requested database users. at /usr/local/cpanel/Cpanel/DBAdmin.pm line 160
	Cpanel::DBAdmin::_log_error_and_output_return(Cpanel::Mysql=HASH(0x2278e48), 'The cPanel user \xE2\x80\x9C[_1]\xE2\x80\x9D is not allowed to grant access to any of the requested database users.', 'recenze') called at /usr/local/cpanel/Cpanel/Mysql.pm line 522
	Cpanel::Mysql::_dbowner_to_all_with_ownership_checks(Cpanel::Mysql=HASH(0x2278e48), 'method', 'REVOKE', 'users', HASH(0x2279640)) called at /usr/local/cpanel/Cpanel/Mysql.pm line 465
	Cpanel::Mysql::remove_dbowner_from_all(Cpanel::Mysql=HASH(0x2278e48), 'cpses_reGmRPM2kn') called at bin/cpses_tool.pl line 139
	bin::cpses_tool::__ANON__() called at bin/cpses_tool.pl line 155
	bin::cpses_tool::action_REMOVETEMPDBOWNER('bin::cpses_tool', HASH(0x2274078)) called at bin/cpses_tool.pl line 64
	bin::cpses_tool::process_request(HASH(0x2274078)) called at bin/cpses_tool.pl line 51
	bin::cpses_tool::script('bin::cpses_tool') called at bin/cpses_tool.pl line 27
/usr/sbin/nscd: nscd not running!

[2014-11-15 16:14:39 +0000] info [cpses_tool] MYSQL: Remove dbuser cpses_reh3G7oHUw for owner recenze on 107.*.*.*
the IP mentioned on the last line is old WHM IP which is no longer used after i transfered WHM VPS to another dedicated server..
 

postcd

Well-Known Member
Oct 22, 2010
717
19
68
this is what added mysqls back to cpanel:
To resolve this, I used the Database Mapping Tool, in WHM >> SQL Services, to add these databases and the database user to the cPanel account. I then added the database user to all the databases from within cPanel account.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,228
463
Hello :)

I am happy to see the issue is now resolved. Thank you for updating us with the outcome.