[MySQL] Add users, give different administrative rights

Add new users
Format: Grant permissions on database. * To User name @ login host identified by "password"
For example, add a user user1 password to Password1, so that it can log on to the computer, and all databases have query, insert, modify, delete permissions. First, use the root user to connect to MySQL, and then type the following command:
Grant Select,insert,update,delete on * * to [email protected] identified by "Password1″;
If you want the user to be able to log on to MySQL on any machine, change localhost to "%".
If you do not want to User1 have a password, you can make another command to remove the password.
Grant Select,insert,update,delete on mydb.* to [e-mail protected] identified by "";

[MySQL] Add users, give different administrative rights