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 database confusion

Discussion in 'Database Discussions' started by melissadana, Mar 27, 2009.

  1. melissadana

    melissadana Registered

    Joined:
    Mar 20, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    51
    Hi,

    I'm really new here, so I'm sure this is a simple problem, but I would really appreciate the help! :)

    I'm trying to set up Indexhibit, a web application for building websites, but first I need to provide access to my database information. Though I already have my host, db name, db user, and password, and I'm pretty sure they're correct, I'm still not able to connect.

    I have noticed that, although I can create a database when I go through the "MySQL Databases" link on the home page, when I go through "phpMyAdmin," it says I do not have the privileges to create a database.


    I'm guessing that therein lies the problem, but thats really the only clue I have. Has anyone else run into a similar problem, or have any leads as to where I can try to figure it out?

    I have also guessed that maybe my formatting for my db, user, and host are incorrect? (localhost, master_db, master_user, passsword?)

    I'd appreciate any clues cause I'm feeling really dense right now.

    Thanks!
     
    #1 melissadana, Mar 27, 2009
  2. ChrisRHS

    ChrisRHS Well-Known Member

    Joined:
    Jul 12, 2006
    Messages:
    292
    Likes Received:
    5
    Trophy Points:
    168
    From my understanding, you will not be able to create a database through phpmyadmin, you are only able to create a database through the CPanel interface. I suggest you use the Database Wizard to create a new database, database user and password. Make sure you select "all" when you hit the permissions page. Once done, use the values you have entered as your sql details.

    Make sure you have the correct format for the db and username, which goes like this:

    user_dbname
    user_dbusername

    For example, if your login name for Cpanel is melissad, and you create a db named "indexdb", with the user name for that database of "indexuser", the details you need to enter in your config file would be:

    melissad_indexdb --> database name
    melissad_indexuser --> database user name

    Hope this helps
     
    #2 ChrisRHS, Mar 27, 2009
  3. melissadana

    melissadana Registered

    Joined:
    Mar 20, 2009
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    51
    Thanks!!!

    I had been creating databases and usernames on the "MySQL Database" page, which doesn't ask you anything about privileges.

    Thanks again!
     
    #3 melissadana, Mar 27, 2009
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL database confusion
  1. osirion

    MySQL Database Restoration from Full Backup

    osirion, Jun 14, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    99
    cPanelMichael
    Jun 14, 2017
  2. akash7130

    Import database in mysql?

    akash7130, May 19, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    141
    cPanelMichael
    May 22, 2017
  3. raafat1994

    Problem with MySQL database

    raafat1994, May 3, 2017, in forum: Database Discussions
    Replies:
    2
    Views:
    176
    cPanelMichael
    May 4, 2017
  4. brianmp1

    Switch to Remote MySQL Database

    brianmp1, Mar 3, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    462
    cPanelMichael
    May 8, 2017
  5. copernic2006

    Converting RoundCube database from MySQL to SQLite question

    copernic2006, Feb 28, 2017, in forum: E-mail Discussions
    Replies:
    2
    Views:
    299
    cPanelMichael
    Feb 28, 2017

Share This Page