How to grant permission to new user created in mysql? 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 :

GRANT SELECT, INSERT, DELETE ON database TO username@'localhost' IDENTIFIED BY 'password';


To see a list of the privileges that have been granted to a specific user:

select * from mysql.user where User='username';


OR

CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';