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 - unable to create new databases

Discussion in 'General Discussion' started by gdns, Jan 19, 2009.

  1. gdns

    gdns Active Member

    Joined:
    Feb 12, 2007
    Messages:
    29
    Likes Received:
    0
    Trophy Points:
    151
    All users is denied to create new databases, and is rejected with:
    Sorry, you have exceeded the maximum allowed databases.

    in the cpanel interface




    cPanel 11.24.4-R33311 - WHM 11.24.2 - X 3.9
    FREEBSD 6.3 amd64 on standard
     
  2. cPanelStephen

    cPanelStephen Active Member
    Staff Member

    Joined:
    Aug 7, 2007
    Messages:
    25
    Likes Received:
    0
    Trophy Points:
    51
    I have been unable to replicate this in my test environments. What is the output from the following commands, with $USERNAME substituted with the name of an affected user?

    grep SQL /var/cpanel/users/$USERNAME
    ls /var/db/mysql/ | grep -c $USERNAME

    I would recommend opening up a support ticket if this behavior is server wide, so we can log in and isolate what is causing this behavior within your environment.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,216
    Likes Received:
    10
    Trophy Points:
    313
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    If these users are not exceeding the maximum number of databases permitted and are experiencing this issue, I recommend submitting a support ticket so our technical analysts can diagnose and resolve this issue: http://tickets.cPanel.net/submit
     
  4. Stuff4Toys

    Stuff4Toys Member

    Joined:
    Oct 3, 2008
    Messages:
    17
    Likes Received:
    0
    Trophy Points:
    51
    Location:
    Wisconsin
    In WHM click "Modify and Account" and double check the number of MySQL databases allowed. I think mine was set up to default at Zero (0)

    JOhn ><>
     
    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