Hi!!
Login as root (any user who has got GRANT privilges..)
Same as u did earlier..( I have tested on my local machine with ur grant statement & it worked fine..as I can login using bookorama/bookorama123 from the same machine...)
C:\mysql\bin>mysql -uroot -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 39 to server version: 4.0.18-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
(root@localhost) [(none)]> grant select, insert, update, delete, index, alter, create, drop ON test.* TO 'bookorama'@'%' IDENTIFIED BY 'bookorama123';
Query OK, 0 rows affected (0.00 sec)
(root@localhost) [(none)]> flush privileges;
Query OK, 0 rows affected (0.01 sec)
Now logged with bookorama..
C:\mysql\bin>mysql -ubookorama -p
Enter password: ************
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 69 to server version: 4.0.18-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
Check whether the DB books exists.. coz above grant statemnt will work even if its(books) not there but won't allow u to do anything after that...
Take a look at here for more details..
http://dev.mysql.com/doc/mysql/en/adding-users.html
http://www.devarticles.com/c/a/MySQL/Creating-Users-and-Setting-Permissions-in-MySQL/1/
Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221