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,569
    coffeeboyuk
    Dec 5, 2017
  2. strensnik

    Unable to Complete MySQL/MariaDB Upgrade

    strensnik, Oct 6, 2018, in forum: Database Discussion
    Replies:
    8
    Views:
    250
    cPanelLauren
    Oct 12, 2018
  3. alandioda

    Unable to connect to my mysql database

    alandioda, Oct 8, 2017, in forum: Database Discussion
    Replies:
    2
    Views:
    888
    cPanelMichael
    Oct 9, 2017
  4. Orxan204

    New Thread mysqli_connect(): (HY000/2002): No such file or directory

    Orxan204, Nov 20, 2018 at 4:33 PM, in forum: Database Discussion
    Replies:
    0
    Views:
    30
    Orxan204
    Nov 20, 2018 at 4:33 PM
  5. codepoet

    New Thread systemctl start mariadb error but mysql running

    codepoet, Nov 19, 2018 at 9:14 PM, in forum: Database Discussion
    Replies:
    0
    Views:
    19
    codepoet
    Nov 19, 2018 at 9:14 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