Community Forums
Connect with us on LinkedIn
+ Reply to Thread
Results 1 to 12 of 12
  1. #1
    Member
    Join Date
    Sep 2011
    Posts
    90
    cPanel/Enkompass Access Level

    DataCenter Provider

    Default MySQL Database creation problem

    Hello,

    When I try create a new MySQL database, in any account, comes the following error message:
    MySQL Database creation problem-erro_1.jpg

    But, the comunication with the MySQL Server seems to be ok...
    MySQL Database creation problem-erro_2.jpg

    Any ideia?

  2. #2
    cPanel Staff cPanelSalinas's Avatar
    Join Date
    Feb 2009
    Posts
    355

    Default Re: MySQL Database creation problem

    Was it working fine before? If you restart the Enkompass WCF and Web Server services, does the error go away?

  3. #3
    Member
    Join Date
    Sep 2011
    Posts
    90
    cPanel/Enkompass Access Level

    DataCenter Provider

    Default Re: MySQL Database creation problem

    Hello,

    Sorry for my delay to respond.
    I tested this a bit and the problem remains the same.

    Any suggestion?

  4. #4
    Support Manager cPanelEric's Avatar
    Join Date
    Nov 2007
    Location
    Texas
    Posts
    488
    cPanel/Enkompass Access Level

    Root Administrator

    Default Re: MySQL Database creation problem

    Howdy,

    I would try removing/readding the mysql server to your Enkompass domain.

    Thanks!

  5. #5
    Member
    Join Date
    Sep 2011
    Posts
    90
    cPanel/Enkompass Access Level

    DataCenter Provider

    Default Re: MySQL Database creation problem

    The error persists too...

  6. #6
    cPanel Staff cPanelSalinas's Avatar
    Join Date
    Feb 2009
    Posts
    355

    Default Re: MySQL Database creation problem

    Log into PhpMyAdmin as 'root', and make sure 'root' has "ALL PRIVILEGES".

  7. #7
    Member
    Join Date
    Sep 2011
    Posts
    90
    cPanel/Enkompass Access Level

    DataCenter Provider

    Default Re: MySQL Database creation problem

    Yes, the root have ALL privileges, from all hosts

  8. #8
    cPanel Staff cPanelSalinas's Avatar
    Join Date
    Feb 2009
    Posts
    355

    Default Re: MySQL Database creation problem

    I don't have any other ideas.

  9. #9
    Member
    Join Date
    Sep 2011
    Posts
    90
    cPanel/Enkompass Access Level

    DataCenter Provider

    Default Re: MySQL Database creation problem

    I rellay need a help with this case.
    I reinstall the MySQL Server, and the error persists. I deleted the server, add again in the Enkompass, and now I have the folloing error:
    MySQL Database creation problem-mysql_error.jpg

  10. #10
    Member
    Join Date
    Sep 2011
    Posts
    90
    cPanel/Enkompass Access Level

    DataCenter Provider

    Default Re: MySQL Database creation problem

    I just realized that the original problem happens on another server with Enkompass I use. It may be some bug or something with the setup mode I'm using for the services?

  11. #11
    Member
    Join Date
    Sep 2011
    Posts
    90
    cPanel/Enkompass Access Level

    DataCenter Provider

    Default Re: MySQL Database creation problem

    Hello,

    I saw that there are some cases like mine: http://forums.cpanel.net/f205/phpmya...172257-p2.html I only wish whether it is a question that can be corrected or whether it will be necessary to open a ticket.

  12. #12
    Member
    Join Date
    Sep 2011
    Posts
    90
    cPanel/Enkompass Access Level

    DataCenter Provider

    Default [SOLVED] Re: MySQL Database creation problem

    I found the solution: the user root of MySQL need not only ALL PRIVILEGES, but too the GRANT privilege:

    MySQL Database creation problem-mysql_error2.jpg

    Thanks for the "help", in this case.

Similar Threads & Tags
Similar threads

  1. Replies: 10
    Last Post: 01-23-2011, 08:58 AM
  2. MySQL Database Creation
    By thearchitect in forum cPanel Developers
    Replies: 3
    Last Post: 10-17-2009, 01:31 AM
  3. mysql problem - new version / old database
    By Ben Harrison in forum Database Discussions
    Replies: 8
    Last Post: 04-06-2009, 02:44 AM
  4. MySql User Creation Problem
    By odtufatih in forum Database Discussions
    Replies: 2
    Last Post: 04-26-2005, 05:07 AM
  5. Mysql add database problem.
    By vucsht in forum cPanel and WHM Discussions
    Replies: 0
    Last Post: 07-16-2004, 11:21 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube