Setting database user and password

[gorilla1]

I have set up mysql with phpmyadmin on my localhost. I created a database using phpmyadmin. Now i want to create a user and password for the database. Can I use phpmyadmin to do this? Or do I need something else? How do I go about doing it? I went into the mysql user table and tried setting the 'host' , 'user' and 'password' fields, but no luck.

G

[Benahimvp]

You have to use the GRANT (http://www.mysql.com/doc/G/R/GRANT.html) command.

[gorilla1]

Thanks, Benahimvp, this is what I used, and it worked:

GRANT ALL PRIVILEGES ON db.* TO user@localhost IDENTIFIED BY 'passw'

G

:D