Set access right to Mysql

[Anon]

Anyone can tell me how to set the access right to Mysql database ?

For example one user is called "happymane", password is "happy". I specified one mysql database called "productdb" for this user to use. What are the command, and how to set the read/write right to him.
Thank you.

[Anon]

GRANT select,update,delete,insert
ON productdb.*
TO happymane@localhost
IDENTIFIED BY 'happy';

[Anon]

How come I can't create database on mysql, I am root user ? When I type the command "mysqladmin create mydb -p"

After that the error come out:
"mysqladmin:connect to server at '' failed; error:'Access denied for user: '[e-mail]'

I also try the command:
"mysqladmin -h localhost create mydb -p"
"mysqladmin -h 192.168.0.10 create mydb -p"
"mysqladmin -h /var/lib/mysql create mydb -p"
"mysqladmin -h server.company create mydb -p"

but still have same problem, that's why I can't set access right of database at the next step.

Thank you.