Hey guys I jus got apache 2.0, mysql, and php up and running on my windows xp server. I am havin sum issues with MySQL however. I know Command Prompt is required for it, but how can i setup up a database which i can connect to with php?

I don't run any windows servers so not sure where you could find the console access but phpmyadmin should work. With phpmyadmin you can login as root and create database and users from there.
http://www.phpmyadmin.net/

Use MySQL COntrol Center available at http://www.mysql.com/products/mysqlcc/

for control center what would i put for username, password, and hostname?

If it's a base installation, HOST would be localhost, Username would be root, and blank password. Should get you in.

hmmm HOST didnt wrk, I tried using the name of my computer which is "SERVER" but i got an error that says that Host is not allowed to connect to the MySQL server......im on dsl btw

thanxs guys i got MySQL to wrk with phpmyadmin and control center :)