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.

All SQL Databases 6 / 10 But user only has 1 databse

Discussion in 'Database Discussions' started by HaoSs, Jul 14, 2015.

  1. HaoSs

    HaoSs Member

    Joined:
    Dec 1, 2014
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Brasov, Romania, Romania
    cPanel Access Level:
    Root Administrator
    Initially user was set to 5 databases. but he was showing 6/5 and could not crate more. He only has 1 database in cpanel account. and pypmyadmin only shows 1 database.
     
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,145
    Likes Received:
    34
    Trophy Points:
    48
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    I can see you have root access so please check this through command line, How many DB's are created under this user ? Also, You can check it under mysql data directory and try to run following command

    Code:
    /usr/local/cpanel/bin/setupdbmap
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Please let us know if the issue persists after running the following command:

    Code:
    /usr/local/cpanel/scripts/update_db_cache
    Thank you.
     
Loading...

Share This Page