To create a user in mysql use -
CREATE USER 'ravi'@'localhost' IDENTIFIED BY 'password';
To grant all permissions use -
GRANT ALL PRIVILEGES ON *.* TO 'ravi'@'localhost'
WITH GRANT OPTION;
GRANT ALL ON *.* TO 'ravi'@'localhost'
WITH GRANT OPTION;
//also works
To grant selected permissions use -
GRANT SELECT,DELETE,UPDATE ON *.* TO 'ravi'@'localhost'
WITH GRANT OPTION;
Reference : MySQL Reference
Enjoy :)
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.