MySQL databases missing but they exist in phpadmin

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:

[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

November 15, 2014 16:28

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.

tank

November 15, 2014 18:50

Sounds like a permission problem. I would just import each database and assign a new user. Do this from the client side panel under backups.

cPanelMichael

November 17, 2014 14:48

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

MySQL databases missing but they exist in phpadmin

Comments

Didn't find what you were looking for?