MySQL/Apache

This is a discussion on MySQL/Apache within the Tech Board forums, part of the Community Boards category; Ok so i installed MYSQL 4 and Apache something (the newest) on my windows xp box. I have both setup ...

  1. #1
    RoD
    RoD is offline
    Redundantly Redundant RoD's Avatar
    Join Date
    Sep 2002
    Location
    Missouri
    Posts
    6,331

    MySQL/Apache

    Ok so i installed MYSQL 4 and Apache something (the newest) on my windows xp box.

    I have both setup as a service and running. My goal is to install phpnuke (www.phpnuke.com) but trying to follow the instructions for nuke im getting nowhere because i have no idea how to use mysql or apache.

    I use mysql control center to manage MYSQL. Heres the install txt file, anyone break it down into install for dummies? I just need to do the first parts setting up the database i know the rest.

  2. #2
    Software Developer jverkoey's Avatar
    Join Date
    Feb 2003
    Location
    University of Waterloo
    Posts
    1,904
    it says in there that you can skip some steps if you have phpMyAdmin installed, do you?

    -edit-

    the instructions look pretty simple, i haven't technically worked with php-nuke before, but i think that if you have phpMyAdmin installed, it should be somewhat easy

    -ok-
    1) Create a database called, for example, nuke:
    mysqladmin create nuke

    that looks like a command line thing, it will create a database called nuke in your sql database---in phpMyAdmin you can just manually create the database in the interface

    2) Now fill the databases with the tables in nuke.sql file:
    mysql nuke < nuke.sql

    i guess this just basically loads the premade sql file in to the database, haven't seen this function in phpMyAdmin before, but i've never used it. If you use the command line, it might be easier to just do that

    3) In order to use the ultramode.txt news file please be sure to chmod 666.
    This file is used to show news from your site in some old programs and
    frontends and is reserved to future use in PHP-Nuke. For backend use
    backend.php file instead.

    meh, don't really think this step does much

    4) That's it!... now you need to edit the file "config.php" to set the
    database options. Please read carefully the instruction on that file!
    After that, point your browser to:
    http://yourdomain.com/admin.php

    i'm guessing you just need to set up the password and login info for your database, and also set the name of the sql database you created....
    Last edited by jverkoey; 04-07-2004 at 10:47 PM.

  3. #3
    RoD
    RoD is offline
    Redundantly Redundant RoD's Avatar
    Join Date
    Sep 2002
    Location
    Missouri
    Posts
    6,331
    Yea after step 3 i have done it before.

    I DO have phpmyadmin but i cant even install it because that confuses me even more than phpnuke

  4. #4
    Software Developer jverkoey's Avatar
    Join Date
    Feb 2003
    Location
    University of Waterloo
    Posts
    1,904
    hmm, well, what exactly are you having trouble with? I never had to install phpmyadmin on my website, so i can't help you much with that, but if you tell me what you don't understand i might be able to help

  5. #5
    RoD
    RoD is offline
    Redundantly Redundant RoD's Avatar
    Join Date
    Sep 2002
    Location
    Missouri
    Posts
    6,331
    welp i dont know anything about mysql or its databases. Basically im having trouble with those 3 steps, i dont know what command line to use, anything.....god i feel like a newbie again.

  6. #6
    Software Developer jverkoey's Avatar
    Join Date
    Feb 2003
    Location
    University of Waterloo
    Posts
    1,904
    http://www.freewebmasterhelp.com/tutorials/phpmysql/1
    where i learned php/sql ^^^
    -note- this website uses sql commands that should work in your command line thing that you said you have, the "mysql control center"

    http://forums.devnetwork.net/index.php

    good message board for php/sql help, might want to ask questions there too

  7. #7
    RoD
    RoD is offline
    Redundantly Redundant RoD's Avatar
    Join Date
    Sep 2002
    Location
    Missouri
    Posts
    6,331
    Thnx alot, i appreciate it.

  8. #8
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    If you don't know the command line stuff, download the Control Center from mysql.com. You can do everything through a GUI and then just create your website to work with what you created. It will save you a LOT of time and hassle.

  9. #9
    RoD
    RoD is offline
    Redundantly Redundant RoD's Avatar
    Join Date
    Sep 2002
    Location
    Missouri
    Posts
    6,331
    i did, i added a database and all but i assume im doing it wrong because it cant connect....

  10. #10
    PC Fixer-Upper Waldo2k2's Avatar
    Join Date
    May 2002
    Posts
    2,001
    you have to set it as the default db
    PHP and XML
    Let's talk about SAX

  11. #11
    RoD
    RoD is offline
    Redundantly Redundant RoD's Avatar
    Join Date
    Sep 2002
    Location
    Missouri
    Posts
    6,331
    well i did the "test" option to learn it isnt working

  12. #12
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    I couldn't connect to mine either when I first installed it... I eventually ended up using the username I setup with no password and it worked.

  13. #13
    RoD
    RoD is offline
    Redundantly Redundant RoD's Avatar
    Join Date
    Sep 2002
    Location
    Missouri
    Posts
    6,331
    ok lemme fire up that machine ina few, just got home, and see if going no password helps me out.

  14. #14
    RoD
    RoD is offline
    Redundantly Redundant RoD's Avatar
    Join Date
    Sep 2002
    Location
    Missouri
    Posts
    6,331
    ok i found the connection problem. I misspelled my hostname both times, im retarded. Now i just need to figure out how to fill the database with the nuke file.

Popular pages Recent additions subscribe to a feed

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21