Im very new to MySQL and im learning from "PHP and My SQL Web Development" by Luke Welling and Laura Thompson.

Ive successfully installed MySQL and am using the console, ive created a new database (books), have created users, granted and revoked privileges.

The book then tells me to create a User for the Web:

So ive created a user for the database books to bookorama identified by the user bookorama123

The book then says to quit and log in as the web user, when i try to do so i get a very breif message saying access denied then the conolse shuts down.

according to the book this is normal, it says if this happens to delete the anonymous users.

only problem of course is that it doenst tell me how to do so.

So Far I Have Done the Following

the book told me to crete a couple of accounts.

the first for sally, and all the grants and revokes worked.

then it said to create "a user for the web"

mysql> grant select, insert, delete, update
on books.*
to username identified by 'password';

then its tells me to quit the MySql console and log in as the web user, but it wont let me do that.

when i log in, i put in the password i set up when installing MySql.

im not sure if i am the root user.

ok, i have figured out how to show the users set up, the following are listed:

root
danny (instructed by the book to set up)
root
sally (instructed by the book to set up)
bookorama (instructed by the book to set up - this is the "web user")

any help would be much appreciated