insane mySQL n00b question

[pizzaguy234]

ok, ok, this is stupid, and i can't figure it out, please help me, please!?!

right, down to business

i seem incapable of logging onto mySQL!!! this really is silly, but annoying.

i have mySQL installed on a local server (my computer) and it seems to work fine, as i have developed phpbb on it just fine.

now, when i open mysql.exe, to get to the mysql console thingy, the command prompt is mysql> BUTTTTTTTT in the documents accompanying mysql it says, when you begin to log in to mysql the prompt will be root>

what is going on?? i need to log on, because it will not allow me to create databases at the moment, and i don't want to use the test datasbase, as it has all my phpbb crap in it.

so please help me out, as im sure you will, thank you, andy.

and god am i sick of typing mysql hahaha

[Voetsjoeba]

First of all, the mysql> prompt is perfectly normal. Mine has that as well. I've never seen any root> prompt, so you're fine.

If you have a password for your root account, enter mysql like this:

C:\location\bin\mysql -u root -p

It will ask you for a password. Enter it, and it should show the mysql> prompt. Try "create database foo;", see if it works.

If you don't have a root password, use

C:\location\bin\mysql -u root

And do the same thing. Both should work.