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
     
    #1 gdns, Jan 19, 2009
  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...
    #2 cPanelStephen, Jan 19, 2009
  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
     
    #3 cPanelDavidG, Jan 19, 2009
  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...
    #4 Stuff4Toys, Jan 21, 2009
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL unable create
  1. coffeeboyuk

    unable to create a database from mysql command line

    coffeeboyuk, Nov 16, 2017, in forum: Database Discussion
    Replies:
    17
    Views:
    1,281
    coffeeboyuk
    Dec 5, 2017
  2. alandioda

    Unable to connect to my mysql database

    alandioda, Oct 8, 2017, in forum: Database Discussion
    Replies:
    2
    Views:
    725
    cPanelMichael
    Oct 9, 2017
  3. Pablo Morales

    Unable to Backup Remote Mysql Directory

    Pablo Morales, Oct 2, 2016, in forum: Data Protection
    Replies:
    5
    Views:
    19,074,983
    Pablo Morales
    Oct 7, 2016
  4. Bdzzld

    Mysqldump failure during automatic backups (max_allowed_packet)

    Bdzzld, Sep 18, 2018 at 1:58 AM, in forum: Database Discussion
    Replies:
    3
    Views:
    23
    cPanelLauren
    Sep 18, 2018 at 1:34 PM
  5. janipewter

    Mysqldump failure on automatic backups

    janipewter, Sep 13, 2018 at 11:25 AM, in forum: Database Discussion
    Replies:
    9
    Views:
    90
    eva2000
    Sep 18, 2018 at 7:33 PM

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.
    Accept Learn More...
    Dismiss Notice