grant all on (database_name).* to (user)@(hostname) identified by '(password)';
this is the command you need. The parenetheses are not needed, I use them to indicate where you have to put in your specific values. If you are just running one machine you can use localhost for you hostname.
further info on the GRANT command. RTFM.
If you run the command as `root', you should use the `--user'
option as shown. The value of the option should be the name of the
login account that you created in the first step to use for
running the server. If you run the command while logged in as that
user, you can omit the `--user' option.
do:
mysql -u root
see if you see somthing like:
----------------+
| current_user() |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)
do:
mysql> select user, password, host from mysql.user;
+------+----------+------------+
| user | password | host |
+------+----------+------------+
| root | | localhost |
| root | | redacted |
| | | redacted |
| | | localhost |
+------+----------+------------+
CREATE DATABASE command should work fine.
http://dev.mysql.com/doc/refman/5.0/en/index.html
http://bytes.com/forum/thread517500.html
Please post back if you have any more problems or questions.