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.

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

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

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

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.

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

Thnx alot, i appreciate it.

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.

i did, i added a database and all but i assume im doing it wrong because it cant connect....

you have to set it as the default db

well i did the "test" option to learn it isnt working

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.

ok lemme fire up that machine ina few, just got home, and see if going no password helps me out.

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.