Access Denied problem...

I am trying to create a new database. At the moment I am using test.
When I installed mysql I did enter a user name and password.

This is the error message that i get:

mysql> create database rbs;
ERROR 1044: Access denied for user: '@127.0.0.1' to database 'rbs'

I am able to connect to the database without using a username and
password. So something with my access must be wrong.
But i dont know what it is...

please can someone help fix this problem.

I am using mysql version 4.0.4

Your user account might not have privileges to create a database. It might be restricted to the root account. There is a way to fix this by giving that username more than default privileges.

Thanks,

How would I give a username more pivilages?

It is easier within a utility like phpmyadmin, simple and graphical, but you could issue a GRANT statement for the user

GRANT * ON *.* TO yourusername;

I THINK thats it, you might want to read up on that in the mysql documentation

Thanks I'll give that a try

I tried this but it didnt work. I got an error saying that there was error in the command.

Any ideas of what else I can do?

Yes, use the correct syntax for the statement. Consult the mysql handbook.