mysql 3.23

[lives4him06]

Im using mysql 3.23 it is freshley downloaded off the internet. I start the program (mysql.exe) on a command line, it starts fine, then i type

create database thejlp;

and it comes up saying that i dont have permission to do this. How do i figure out my 'root' user name and password and how do i connect to the database so that i can complete the above task?

[dalecosp]

Do you have a "mysqladmin" program?

{Sorry if a dumb ??, I don't do SQL on windoze...}

[lives4him06]

yes i do.

[dalecosp]

Try "mysqladmin create dbname" ... ?

[LordShryku]

The default user is "root" with no password.

[lives4him06]

so how do i 'connect' or whatever. I tried

connnect mysql root@localhost;

But that didnt connect, it said unable to find host. i tried every possible combination. Im lost!!!!