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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

GRANT OK but db not see under Cpanel

Discussion in 'Database Discussions' started by webstyler, May 20, 2011.

  1. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    439
    Likes Received:
    0
    Trophy Points:
    166
    Hello

    we have a cpanel account (as "oneno")

    We have a php code that could be create and manage mysql db out of cpanel

    so, create mysql user (as "oneno_u") from cpanel and after GRANT all privileg to "oneno%" database

    we have made this on other 8 server without issue

    now

    this procedure work but under cpanel the db created is not listed..
    we check from root phpmyadmin and seems that when create new db from code this is not put under db
    mysql > db > ..

    We really not understand if is a cpanel issue, or mysql or privileg not correct..

    all server have the same linux/cpanel/mysq/php/..

    :/ any suggest ?
     
  2. EasyNetwork

    EasyNetwork Well-Known Member

    Joined:
    May 14, 2003
    Messages:
    46
    Likes Received:
    0
    Trophy Points:
    156
    Location:
    New York
    cPanel Access Level:
    Root Administrator
    Did you run FLUSH PRIVILEGES; ?
     
  3. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,622
    Likes Received:
    26
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    cPanel 11.28+ has database mapping, so database and database users would need to have the cPanel scripts initiated to map the database to the account properly. Those scripts are at /usr/local/cpanel/bin/dbindex and /usr/local/cpanel/bin/dbmaptool in order to associate the correct database to the correct user account. WHM also includes the Database Map Tool in it.
     
  4. webstyler

    webstyler Well-Known Member

    Joined:
    Nov 20, 2003
    Messages:
    439
    Likes Received:
    0
    Trophy Points:
    166
    All work fine
    db added are viewed under cPanel only after upcp
     
Loading...

Share This Page