[MySQL] Users and Permissions : Grant all on..

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 :)