Cpanel database setup

Discussion in 'Site & Server Administration' started by zed, Aug 9, 2009.

  1. #1
    Hello,
    I am using cpanel control panel. But when I setup databse I easily setup database with username.
    My problem when I tries to install scripts like wordpress script ask for
    database name : ok
    databse password : How to
    Username : ok
    user password : ok

    Also on adding database in cpanel it adds a prefix as user_databse name and user_username.
    Is user_databse is full database name or only databse is ok.
    Same in datbase user.
    Please help me.
     
    zed, Aug 9, 2009 IP
  2. adithya

    adithya Well-Known Member

    Messages:
    568
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    110
    #2
    the full database name is user_database
    and the same applies to user name
     
    adithya, Aug 9, 2009 IP
  3. zed

    zed Member

    Messages:
    57
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    43
    #3
    what about database password field i does not appear their in cpanel.
     
    zed, Aug 9, 2009 IP
  4. jepourlevendetta

    jepourlevendetta Peon

    Messages:
    5
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    i think wordpress only asks for the following things:
    # Database name
    # Database username
    # Database password
    # Database host

    and i also think there is no script that asks you for both "database password" & "user password" 'cause the "database password" = "database user's password" = "user password"

    that is.
     
    jepourlevendetta, Aug 12, 2009 IP
  5. Guttu

    Guttu Peon

    Messages:
    728
    Likes Received:
    88
    Best Answers:
    0
    Trophy Points:
    0
    #5
    there is nothing like db password. You need username and that users password to access the database.
     
    Guttu, Aug 12, 2009 IP
  6. eth1

    eth1 Peon

    Messages:
    10
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Basically you need to create the MySQL user via cPanel > MySQL, and grant the user to the database which can also be done via cPanel > MySQL.

    When you're creating the MySQL user, you will also have to enter a password for the user, that password is the MySQL user password.
     
    eth1, Aug 12, 2009 IP