ERROR 1044: Access denied for user

[theGWS]

I'm on pg 29 of Kevin Yank's book. I'm trying to create the jokes database. At the mysql> prompt I entered:

CREATE DATABASE jokes;

Then, instead of creating the database, it returns this line:

ERROR 1044: Access denied for user: '@localhost' to database 'jokes'

Any clues why or how to fix it? It worked when I was using Win2K and IIS, but since I found out Mac OS X can do this I've started over on that platform.

[theGWS]

I don't know if this is the proper way to do this, but I've been messing around and typed:

mysql -u root

Then it let me create the database called jokes.

[svardaman]

You need to GRANT permissions to the table for the user account you typically use (which shouldn't be root!). I don't know what book you're looking at, but check out chapters on users/permissions.