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

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

  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. Boulder

    Boulder Well-Known Member

    Messages:
    806
    Likes Received:
    46
    Best Answers:
    0
    Trophy Points:
    118
    #2
    Yea.. I can help you.. Just go into your database manager if cpanel? Or in phpmyadmin, if you do not have cpanel? Than make a database and call it what ever you want.. and make a user with permissions to use that database. Than open the file "database.php" and enter there in the file your database name, user name and password, and any other info in that file needed. Like the URL or path to script!

    Once those two things are done, open up install.php in your browser like,

    domainname/admin/install.php

    That should build the data structure for the script and your script should work after that!

    Let me know if need more help!

    Boulder
     
    Boulder, Jan 22, 2008 IP
  3. GoglGourd

    GoglGourd Active Member

    Messages:
    122
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    #3
    ^^ sounds about right. It's difficult to explain without knowing exactly what your setup is; do you have cpanel, do you have phpmyadmin .etc if the above doesn't make sense then reply with some details about your site's control panel .etc..
     
    GoglGourd, Jan 22, 2008 IP
  4. chriswick

    chriswick Peon

    Messages:
    907
    Likes Received:
    17
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Still having problem does anyone have MSN that's willing to give me a hand?

    Please PM me, Chris
     
    chriswick, Jan 22, 2008 IP
  5. urstop

    urstop Peon

    Messages:
    224
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Is your phpadmin and webiste accessible thru the internet or is it somethign local to you?
     
    urstop, Jan 22, 2008 IP
  6. kmap

    kmap Well-Known Member

    Messages:
    2,215
    Likes Received:
    29
    Best Answers:
    2
    Trophy Points:
    135
    #6
    hi

    mysql -u <your username> -p
    Enter your password when prompted

    for this open mysql db page in cpanel and the create a database with name mentioned sphider_db

    then create a user with pass and associate that user with db with all permission

    Regards

    Alex
     
    kmap, Jan 25, 2008 IP