Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 15 of 17
  1. #1
    Member
    Join Date
    Sep 2003
    Posts
    126

    Default Can't create mysql database

    I can't create mysql databases. Message: Sorry, you have exceeded the maximum allowed databases., but I have set unlimited mysql dbs.

    General account information shows:

    MySQL Databases NA / unlimited
    MySQL Disk Space NA Megabytes
    MySQL version 4.1.20-standard

    But I am use mysql 4.1.21, cpanel CURRENT 10.9.0-CURRENT_6.
    Please help me.

    Thanks
    Last edited by fleksi; 09-19-2006 at 09:36 PM.

  2. #2
    Member
    Join Date
    Nov 2004
    Location
    alberta
    Posts
    100

    Default

    i having this issue as well
    think this may be cpanel bug

    Steve

  3. #3
    Member
    Join Date
    Apr 2006
    Posts
    6

    Default

    One of my clients is having a similar issue. Am yet to find the cause.

  4. #4
    Member
    Join Date
    Nov 2004
    Location
    alberta
    Posts
    100

    Default

    well for starters i do know it cpanel
    i have switched to stable again

    but when i was using current was saying something about aprlib needs symblic link

    so i yet to check that out when its offpeak

    Steve

  5. #5
    Member
    Join Date
    Feb 2003
    Posts
    205

    Default

    Quote Originally Posted by perfect-games
    i having this issue as well
    think this may be cpanel bug

    Steve
    What's new LOL!

  6. #6
    Registered User
    Join Date
    Dec 2003
    Posts
    4

    Default

    Any word on this??

  7. #7
    Member
    Join Date
    Nov 2004
    Location
    alberta
    Posts
    100

    Default

    i also yet to discover the problem gets worse
    any of you lot having issues with webmail like horde

    this iswhat i getting

    Internal Server Error

    Unable to open engine binary (php) at cpsrvd-ssl.pl line 4396
    main:hpHandler() called at cpsrvd-ssl.pl line 3305
    main::dodoc_webmaild() called at cpsrvd-ssl.pl line 637
    main::dodoc() called at cpsrvd-ssl.pl line 543



    cpsrvd/10.9.6

    Steve

  8. #8
    Registered User
    Join Date
    Dec 2003
    Posts
    4

    Default

    Not seeing the Horde issue here.. just the MySql one. Anyone else?

  9. #9
    cPanel Partner NOC cPanel Partner NOC Badge AndyReed's Avatar
    Join Date
    May 2004
    Location
    Minneapolis, MN
    Posts
    2,223

    Default

    Quote Originally Posted by fleksi
    I can't create mysql databases. Message: Sorry, you have exceeded the maximum allowed databases., but I have set unlimited mysql dbs.
    See if this helps:

    cd /var/cpanel/users
    Find MAXSQL=
    and change the word unlimited to a number, let's say 25
    Save the file and then Restart the cpanel
    /sbin/service cpanel restart
    Andy Reed
    RHCE and CCNA
    ServerTune.com

  10. #10
    Member
    Join Date
    Sep 2003
    Posts
    126

    Default

    I have set the account quota to use a finite number rather than unlimited but still no luck.

    Please help me

  11. #11
    Member
    Join Date
    Sep 2006
    Posts
    7

    Default

    having this issue as well mysql maintenance page is just freaking blank, running "current" why it matters i dont know considering rolling back just breaks even more things. I love spending my weekend trying to resolve their problems.

  12. #12
    Member
    Join Date
    Sep 2006
    Posts
    7

    Default

    and let me state before someone suggests it, no the ever so popular "upcp --force" will not work on this one nor will anything else in /scripts. Nothing in the error logs

  13. #13
    cPanel Partner NOC cPanel Partner NOC Badge AndyReed's Avatar
    Join Date
    May 2004
    Location
    Minneapolis, MN
    Posts
    2,223

    Default

    Quote Originally Posted by otsh
    and let me state before someone suggests it, no the ever so popular "upcp --force" will not work on this one nor will anything else in /scripts. Nothing in the error logs
    Did you check the uid.gid of the user with MySQL problem? Make sure the ownership and permission are correct on the /var/mysql/USER_DB
    Does this happen with all users on your server? Did you try adding a DB to the user with the problem, manually?
    Andy Reed
    RHCE and CCNA
    ServerTune.com

  14. #14
    Member baohx's Avatar
    Join Date
    Sep 2003
    Location
    AZ, USA
    Posts
    24

    Default bug entered

    I didn't see a bug for this in bugzilla (at least didn't see one from the bug subjects), so I've entered one. It's 4616.

  15. #15
    Member
    Join Date
    Sep 2004
    Posts
    529

    Default

    Ok... I found out how to fix this... it's different (on the face, under the hood it's likely related) from the unlimited mysql db issue that the last poster posted the bug for.

    I had this issue with a client's account, but I noticed that my account and accounts for other customers worked fine and the mysql page came up in full. The issue seems to stem from accounts that have no existing databases, even though they should be allowed databases. This is probably related to the changes for 'unlimited' databases.

    The fix is simple... go into PHPMyAdmin (I used the root WHM PHPMyAdmin, but I assume that the customer's phpmyadmin would likely work as well) and create a database for the client... name the database in this format: accountname_dbname and then your cpanel mysql page will come back and you can add and edit databases again. NOTE: I would add a new database and delete the one you created through phpmyadmin, because if you used the root phpmyadmin it's likely not going to have the user and permissions settings correct.

    Someone should go ahead and post a bug for this... I don't have the time right now.

Similar Threads & Tags
Similar threads

  1. I can't create mySQL database at cPanel.
    By monsterazor in forum Database Discussions
    Replies: 2
    Last Post: 08-29-2011, 04:08 PM
  2. How I can create a new MYSQL Database
    By malluspecial in forum Database Discussions
    Replies: 3
    Last Post: 08-18-2011, 11:57 AM
  3. Create MySQL Database
    By Quadzoola in forum cPanel and WHM Discussions
    Replies: 4
    Last Post: 09-17-2007, 02:11 PM
  4. Can not create MySQL database in CPANEL!
    By anton_latvia in forum cPanel and WHM Discussions
    Replies: 10
    Last Post: 07-10-2007, 10:34 AM
  5. create mysql database
    By dave2k in forum Database Discussions
    Replies: 2
    Last Post: 01-23-2005, 05:58 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube