MySQL Create User

1.mysql>CREATE USER 'user1'@'localhost' IDENTIFIED BY 'pass1';

2.mysql>GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO 'user1'@'localhost';

OR

mysql>GRANT ALL ON *.* TO 'user1'@'localhost';

If you think the method above is so difficult that you can't accept, you can use the method below:

mysql>GRANT ALL ON *.* TO 'user2'@'localhost' IDENTIFIED BY 'pass1';

And there is another direct method that you can have a try!

mysql>INSERT INTO user (Host,User,Password,Select_priv,Insert_priv)

VALUES('localhost','user4',PASSWORD('pass3'),'Y','Y');