Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL databases missing but they exist in phpadmin

Discussion in 'General Discussion' started by postcd, Nov 15, 2014.

  1. postcd

    postcd Well-Known Member

    Joined:
    Oct 22, 2010
    Messages:
    689
    Likes Received:
    14
    Trophy Points:
    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..
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. postcd

    postcd Well-Known Member

    Joined:
    Oct 22, 2010
    Messages:
    689
    Likes Received:
    14
    Trophy Points:
    68
    this is what added mysqls back to cpanel:
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. tank

    tank Well-Known Member

    Joined:
    Apr 12, 2011
    Messages:
    254
    Likes Received:
    1
    Trophy Points:
    68
    Location:
    Chicago, IL
    cPanel Access Level:
    Root Administrator
    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.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,961
    Likes Received:
    1,821
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    I am happy to see the issue is now resolved. Thank you for updating us with the outcome.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice