Creating users in mysql

[Anon]

I've got mysql installed, and I've got root set up, and I created the database I want the user to access, but I can't get it to create other users. This is how I tried to create the user

grant all on db to bill identified by 'me';

When I try to log it in it says
ERROR 1045: Access denied for user: 'bill@localhost' (Using password: YES)

Any advice/solutions greatly appreciated

[Anon]

Have you done a flush-privileges ?

[Anon]

No. Should I do that after I make every user? What does it do?

[Anon]

Flush privilegs basically reloads the security settings for the whole database system.

The user privilege table is (only) loaded at startup, so any changes that you make to permissions need to be flushed through, hence flush privileges. The details on this are available at:

http://ftp.plig.org/pub/mysql/doc/F/L/FLUSH.html

and overview of adding users at

http://ftp.plig.org/pub/mysql/doc/A/d/Adding_users.html

Hope this helps
Justin