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.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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';
CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password'; GRANT ALL PRIVILEGES ON * . * TO 'newuser'@'localhost';
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
Test. TO 'myUser'@'%';*