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.

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.
     
    #2 cPanelStephen, Jan 19, 2009
  3. cPanelDavidG

    cPanelDavidG Technical Product Specialist

    Joined:
    Nov 29, 2006
    Messages:
    11,277
    Likes Received:
    9
    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 ><>
     
    #4 Stuff4Toys, Jan 21, 2009
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL unable create
  1. Pablo Morales

    Unable to Backup Remote Mysql Directory

    Pablo Morales, Oct 2, 2016, in forum: Data Protection
    Replies:
    5
    Views:
    19,074,539
    Pablo Morales
    Oct 7, 2016
  2. M.Ismail

    Unable to activate MYSQLI from whm

    M.Ismail, Aug 6, 2016, in forum: EasyApache
    Replies:
    1
    Views:
    764
    cPanelMichael
    Aug 7, 2016
  3. kicon

    unable to import the zip backup file of mysql

    kicon, Oct 30, 2015, in forum: Database Discussions
    Replies:
    7
    Views:
    1,064
    Infopro
    Nov 7, 2015
  4. Nirjonadda

    MySQL 5.6 slower than MariaDB 10.2

    Nirjonadda, Aug 21, 2017 at 3:58 PM, in forum: Database Discussions
    Replies:
    4
    Views:
    49
    cPanelMichael
    Aug 22, 2017 at 9:35 AM
  5. Bidi

    Moving MySQL directory

    Bidi, Aug 19, 2017 at 10:46 PM, in forum: Database Discussions
    Replies:
    1
    Views:
    9
    cPanelMichael
    Aug 22, 2017 at 10:44 AM

Share This Page