!!!!!! HELP im a Newbie !!!!!!

[charlessims12]

I have successfully set up my apache web server. I got apache and Php to work together with no problems so far. I've tried to install and set up Mysql 5.0.18 And I dont even know if it's integrated proerly. and im having problems testing everything beacuse my comand prompt is starting me at
C:\ Documents and settings
insted of C:\
So I havent even been able o test the instilation and forget about trying to use it im totally lost...

I've read through at least a hundred pages on mysql.com and I dont know what to do. Maybe im missing something if some one can please help me. or point me in the right direction or anything please help thank you

by the way im using win xp

[chazzy]

during your mysql installation, did you set a root password (assuming you used the binary installer - heavily recommended by me)

if so, at your command prompt type something like this:

mysql -u root -p<yourpasswordhere>

and it should log you in.

for example, on my box, my root password is bob so I type in:

mysql -u root -pbob


and then hit enter to log in.

[Jick]

I remember awhile back when I was having troubles getting MySQL to play nicely. If memory serves there is some sort of trick to it. I think you have to install MySQL first, or something to that effect. An easy alternative would be to use a packaged software such as WAMP (http://www.wampserver.com/).

As for the command prompt, I believe the command you're looking for is "CD" which means "Change Directory". You would do something to the effect of "cd C:\" to change to your C drive.

Hope that helps. :)

[charlessims12]

Thank you very much You have helped me a ton... Is there a difference in me using mysql command line and me using Comand prompt from windows???

[Jick]

Umm... not that I'm aware of. The command prompt is a bit more involved though.

[chazzy]

command line mysql is done, in windows, via command prompt (cmd.exe).

there are gui based tools for connecting as well, the two bigger ones (made by MySQL AB) are MySQL Administrator and MySQL Query Browser. If you like web based, tehre's phpMyAdmin (most people are fmailiar with it since it comes with basically every hosting package)