create database mysql

[donnysrx]

hi all

trying to create a database for a forum software phpBB

I've got the webserver running and php,i can start mysql fine(I doing everything on the same PC, no hosting anywhere)

is mysql 3 different from 4 syntax wise?, my knoppix hdd install has mysql4 on it

i go to command line and type" mysql" then i get


mysql>

so I enter
"create database game_forum"

then i get
->
i dont know what to do next,i need to put in usernames and passwords

the phpBB software has a .php install gui,which i cant get done cos it cant connect to my database,cos I have got one i think

if i type" mysqlshow" i get

->

again

TIA

[fingers99]

You really, really, need to get the manual from the MySQL site (or post on the MySQL list).

[donnysrx]

yeah hi thx for your reply,

but I was already ploughing my way through the manual, I thought the idea of these forums was to help!

anyway I soon realised that the "->" was, if the command line didnt recognise what i was trying to put in, and was waiting for more really

back to the database after i had created the database I didnt realise I had to create accounts for it as well ,that took some finding,I think it wasnt clear because knoppix has already got mysql installed I was skipping some of the manual.

all working fine now,

feel free to post if you have the same difficulties, I do monitor my posts