I'm working my way through a MYSQL and PHP cookbook where they have an example involving a books database.

I entered the following:

grant select, insert, update, delete, index, alter, create, drop
on books.*
to bookorama identified by 'bookorama123';

I then tried:

mysql -D books -h localhost-u bookorama -p

I always get an access denied message and I'm unsure what I'm doing wrong.
The error message reads:

ERROR 1045: Access denied for user: 'bookorama@localhost' (Using password: YES)

Does anyone have any ideas?

Thanks,

try this instead:

without the quote marks you used before. those were getting added as part of the password. When you get a password=YES error it means your password doesn't match the one in the database.