Community Forums
Connect with us on LinkedIn
Community Notice
+ Reply to Thread
Results 1 to 11 of 11
  1. #1
    Registered User
    Join Date
    May 2004
    Posts
    2

    Unhappy Can't create SQL database

    Hi everybody. I am new to cPanel. Anyway I try to create SQL database in cPanel folowing documentation.

    cPanel confirms the action but no SQL database is created. I have tried few times but no database or username is created.

    Eximstats failed is the only error. Does it have anything to do with my problem?

    Can you please point to me how to fix this problem? I am sorry if that is simple problem but I am really new to this stuff and help would be very appreciated.

    I did not install cPanel by myself. I have only account I would like to use.

    Thank you Charles

  2. #2
    Member mickalo's Avatar
    Join Date
    Apr 2002
    Location
    N.W. Iowa
    Posts
    753

    Default Re: Can't create SQL database

    Originally posted by Charles_cz
    Hi everybody. I am new to cPanel. Anyway I try to create SQL database in cPanel folowing documentation.

    cPanel confirms the action but no SQL database is created. I have tried few times but no database or username is created.

    Eximstats failed is the only error. Does it have anything to do with my problem?

    Can you please point to me how to fix this problem? I am sorry if that is simple problem but I am really new to this stuff and help would be very appreciated.

    I did not install cPanel by myself. I have only account I would like to use.

    Thank you Charles
    Make sure MySQL is up and running, which can be verified from the WHM or at the shell prompt to see if the MySQL client is running or not.

    If you can't create the database through the mysql client from the command line, then possibly you or the account that's trying to create the database doesn't have the privileges to create database or isn't setup or allowed to access the MySQL.

    But if eximstats is causing errors, it's possible that MySQL isn't running or failing... need to check the logs.

    Mickalo

    Thunder Rain Internet Publishing

    Providing Internet Solutions that work!
    Custom Perl and Database Programming

  3. #3
    Registered User
    Join Date
    May 2004
    Posts
    2

    Default

    Mysql (4.0.18-standard) is up, at least what cPanel X says.

    Wouldn't I get error when trying to create DB thru cPanel X if I had no the privileges to create database?

    It says DB name was created, but no DB is really created. The same thing is happening when I try to add user.

    I thought that would be pretty simple to create MySQL DB and user. It doesn't look that way so far.

  4. #4
    Member mickalo's Avatar
    Join Date
    Apr 2002
    Location
    N.W. Iowa
    Posts
    753

    Default

    Originally posted by Charles_cz
    Mysql (4.0.18-standard) is up, at least what cPanel X says.

    Wouldn't I get error when trying to create DB thru cPanel X if I had no the privileges to create database?

    It says DB name was created, but no DB is really created. The same thing is happening when I try to add user.

    I thought that would be pretty simple to create MySQL DB and user. It doesn't look that way so far.
    I would verify that infact MySQL is running from the shell prompt, then see if the database was actually created.

    Also make sure, that this account attempting to create the database, has the ability to create MySQL databases, usually setup via the various packages you created in the WHM. On the main login page of the Cpanel, usually on the left side, the is a area that says "Mysql Databases 0/1" or something to that affect. If it says "Mysql Databases 0/0" then they can't create any databases, and you'll need to update or edit the account in the WHM to allow them to create databases.

    Mickalo

    Thunder Rain Internet Publishing

    Providing Internet Solutions that work!
    Custom Perl and Database Programming

  5. #5
    Member
    Join Date
    Jul 2004
    Posts
    6

    Default

    I'm having the dumbest problem of them all. I can't find the command shell. I think I know what I'm doing past that, but I really need to find that shell. Where the heck is it? I read the documentation for cpanel and it never once mentioned it.
    Thanks.

  6. #6
    whs
    whs is offline
    Member
    Join Date
    Feb 2004
    Posts
    9

    Default Command Shell

    Go to this website and download putty

    http://www.chiark.greenend.org.uk/~sgtatham/putty/

    From here you will need to configure a connection to your server. Once connected, you are now in the server via command line (SSH). You can run whatever commands you need to once inside.

  7. #7
    Member
    Join Date
    Dec 2003
    Posts
    14

    Default

    I have the same problem after I completed a server migration. When I login to SSH as root and type 'mysql', I get 'ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)'. Tried resetting the password, didn't work. Seems like the password for the SQL server is not being set correctly. Any ideas?


    Thanks,

    Limedrink.

  8. #8
    Member
    Join Date
    Dec 2003
    Posts
    14

    Default

    Problem solved: Force reset your MySQL password to a password without any special characters.

    Good luck.


    Cheers,

    Limedrink.

  9. #9
    Member
    Join Date
    Nov 2003
    Posts
    26

    Default Same Problem

    Hi, I am having this same problem. When I click Add Db button it says it did, but when it returns back the page it shows no created database.

    1. MySQL is running. Forums and my gameserver plugins are working.
    2. I can not Reset Local MySQL Root Password. It says it did it but I can not access mysql via shell or phpmyadmin.

    So I did a make deinstall for mysql 4.0.13 and installed 4.0.21 and I still get the same problem.

    Any ideas?
    Last edited by gopederick; 10-11-2004 at 03:00 AM.

  10. #10
    Member
    Join Date
    Sep 2003
    Posts
    11

    Default same here

    same problem here and it does not fix with resetting pass .... any other ideas ?

    PROBLEM FIXED .... too much security in my.cnf .... paranoia
    Last edited by subn3t; 12-10-2004 at 12:02 PM.

  11. #11
    Member
    Join Date
    Jan 2005
    Location
    Kolkata, India
    Posts
    15

    Default

    what to do in my.cnf

Similar Threads & Tags
Similar threads

  1. cannot create my sql database for the clients websites
    By siraj in forum Database Discussions
    Replies: 1
    Last Post: 01-15-2008, 09:31 AM
  2. Old SQL database
    By aee156 in forum Database Discussions
    Replies: 2
    Last Post: 07-20-2006, 06:51 AM
  3. Old SQL database
    By aee156 in forum cPanel and WHM Discussions
    Replies: 2
    Last Post: 07-20-2006, 06:51 AM
  4. Replies: 0
    Last Post: 05-29-2006, 01:31 PM
  5. Can't create SQL database
    By Charles_cz in forum cPanel and WHM Discussions
    Replies: 10
    Last Post: 04-22-2005, 04:34 AM
Linkedin       Facebook       Twitter       RSS       Flickr       YouTube