1,CREATE USER语法
CREATE USER user identified by '123456'
2,DROP USER语法
drop user user@localhost;
3,SET PASSWORD语法
set password for user=password('123456');
4,GRANT和REVOKE语法
grant all privileges on db.* to user@localhost identified by '123456';
REVOKE ALL PRIVILEGES, GRANT OPTION FROM user@'%';
revoke all privileges on db.* from user@'192.168.1.1';