Create a database

[adiem]

I have installed Microsoft-IIS/5.0 with PHP and also MySQL 4.1.8-nt.
I'm trying to setup a Bulletin Board based on MySql and I got stuck on connecting to the database. The installation is asking for the database name and a username and password. When I installed MySQL I had to provide a password for the root account - I tried that with "mysql" in the name of the database but is telling me "Couldn't connect to a database using the specified information."
I don't know how I should create a database and what rights I have to give to the username that is going to use it.
I installed also MySQL Administrator hoping that I will find a menu that I can use to create a database...

Install to what MySQL database?

Host Server : localhost
Database Name : ?
Database Username : ?
Database Password : ?
Database Port : 3306

If you can direct me to a document where I can find some directions on how to create the database I would really appreciate it.

Thank you

 

[Bastien]

there are four basic accounts installed by default

root from localhost no password
root from anwhere no password
user from localhost no password
user from anywhere no password

http://dev.mysql.com/doc/mysql/en/CREATE_DATABASE.html

personally i would dl phpmyadmin, i find it the easiest and best tool to admin the database

Bastien

Cat, the other other white meat