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:
    432
    Likes Received:
    0
    Trophy Points:
    16
    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:
    6
    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,623
    Likes Received:
    21
    Trophy Points:
    38
    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:
    432
    Likes Received:
    0
    Trophy Points:
    16
    All work fine
    db added are viewed under cPanel only after upcp
     
Loading...

Share This Page