The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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:
    624
    Likes Received:
    6
    Trophy Points:
    18
    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..
     
  2. postcd

    postcd Well-Known Member

    Joined:
    Oct 22, 2010
    Messages:
    624
    Likes Received:
    6
    Trophy Points:
    18
    this is what added mysqls back to cpanel:
     
  3. tank

    tank Well-Known Member

    Joined:
    Apr 12, 2011
    Messages:
    236
    Likes Received:
    0
    Trophy Points:
    16
    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:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page