I want to create new user and want to give them specific permission like inset, update and delete. But how to create new user and give them permission i don't know.
Any help please.
It would be something like this :
To see a list of the privileges that have been granted to a specific user:
You can use GRANT syntax to give user permission: http://dev.mysql.com/doc/refman/5.0/en/grant.html
For example if you would like to give SELECT permission on TEST database for myUser then:
GRANT SELECT ON
There is a GUI tool called SQLyog using which you can easily add Users, Give permission, revoke permission and all other User Management activities: