MySQL databases missing but they exist in phpadmin

[postcd]

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]

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]

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]

Hello

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