Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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. Shishupal Kumar

    How to Create Mysql Database using SSH in WHM

    Shishupal Kumar, Mar 12, 2018, in forum: Database Discussions
    Replies:
    5
    Views:
    153
    cPanelMichael
    Mar 15, 2018
  2. Luis Gil

    Database error, Can't connect to local MySQL server through socket

    Luis Gil, Feb 13, 2018, in forum: Database Discussions
    Replies:
    3
    Views:
    268
    Luis Gil
    Feb 15, 2018
  3. VJIADIS

    mysql databases (only) backup

    VJIADIS, Jan 18, 2018, in forum: Data Protection
    Replies:
    1
    Views:
    233
    cPanelMichael
    Jan 19, 2018
  4. coffeeboyuk

    unable to create a database from mysql command line

    coffeeboyuk, Nov 16, 2017, in forum: Database Discussions
    Replies:
    17
    Views:
    730
    coffeeboyuk
    Dec 5, 2017
  5. Sametto Chan

    MySQL Database crashed/CPU higher on server to down

    Sametto Chan, Oct 21, 2017, in forum: Workarounds and Optimization
    Replies:
    10
    Views:
    636
    Sametto Chan
    Oct 26, 2017

Share This Page