Granting access on MySQL

[Supote Leelasupphakorn]

> Hello,

> I need to grant a user access to a database. How can
I do it?

> This is what I've tried:

> mysql> grant all on databasename.* to username;

> I got no error messages, but I after connecting as >
the user, I couldn't use the database.

Hi,
  Finally, don't forget to "flush privileges" or
restart
your mysql daemon after you granted permissions.

Cheer,


________________________________________________________________________
Want to chat instantly with your online friends?  Get the FREE Yahoo!
Messenger http://uk.messenger.yahoo.com/