Need some help with setting up an SQL database +Rep for anyone that helps.

Discussion in 'MySQL' started by chriswick, Jan 22, 2008.

0
  1. #1
    I downloaded a script that lets people search for pages on my site but I've never worked with an SQL database and need some help in what to do.

    The script is sphider.eu

    and the install guide says this but I understand none of it.

    can anyone give me an idoits guide step by step on how to install it the SQL is hosted on PHPMyAdmin.

    Cheers, Chris
     
    chriswick, Jan 22, 2008 IP
  2. richrf

    richrf Active Member

    Messages:
    1,101
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    88
    #2
    Hi,

    Where are you hosting your script. I use Hostgator and create MySQL databases from the cPanel. Do you also have cPanel administration?

    Rich
     
    richrf, Jan 22, 2008 IP
  3. Colbyt

    Colbyt Notable Member

    Messages:
    3,224
    Likes Received:
    185
    Best Answers:
    0
    Trophy Points:
    210
    #3
    Replace this:
    With this:

    Login to your control panel,
    Click the mysql button,
    Enter a database name in the create DB box, copy name to notepad
    go back, create a user and a password for that user, copy name and pass to notepad
    go back, add that user to the DB with ALL priviledges.
    logout.

    Open the config whatever script and paste the info from notepad to the correct place.
    Run the install program per the directions.

    Note that the DB name and username will take the form of yourusername_DBname.
     
    Colbyt, Jan 22, 2008 IP