Installing a mysql database

Discussion in 'MySQL' started by aa262, Sep 22, 2008.

  1. #1
    Bought a site from someone and I can figure how to install the the program files but not the db files.Is there an easy way to do that if no configuring is required

    Can anyone point me in the right direction on how to learn how to do that
     
    aa262, Sep 22, 2008 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    What sort of server are you hosting this on?
     
    jestep, Sep 22, 2008 IP
  3. aa262

    aa262 Active Member

    Messages:
    307
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #3
    aa262, Sep 22, 2008 IP
  4. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #4
    Do you have a control panel like cpanel, or plesk, or do you have ssh access?
     
    jestep, Sep 22, 2008 IP
  5. aa262

    aa262 Active Member

    Messages:
    307
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #5
    I have cpanel
     
    aa262, Sep 22, 2008 IP
  6. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #6
    In cpanel, go to databases
    ->click on MySQL Databases
    -> Enter a name for a new database and click the create database button
    -> then return to the databases page
    -> Create a user by entering a username and password
    -> then return to the databases page
    Go down to the add User to Database section and add the user you just created to the database you just created. Typically you will want to give Select, Insert, Update, Delete Privileges unless they need administration rights for some reason.

    Assuming there are no errors, you should have a working database now. Your connection parameters would be the username, database and password you just created, and localhost for the host. Also, cpanl appends account names to the database name and the username, so make sure to include these. You can see the full database and username in cpanel as well, should look like account_databasename and account_username.
     
    jestep, Sep 22, 2008 IP
  7. aa262

    aa262 Active Member

    Messages:
    307
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #7
    One more question After i do that all I have to do is to install upload the
    backup of the datanase
     
    aa262, Sep 25, 2008 IP