mysql用户添加、删除、更改密码

增加用户
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON *.* TO 'username'@'localhost' IDENTIFIED BY 'stupid';
GRANT ALL PRIVILEGES ON *.* TO username@localhost IDENTIFIED BY 'something' WITH GRANT OPTION;

先用root帐户登入mysql，然后执行：
delete from user where user='username';

改密码
先用root帐户登入mysql，然后执行：
UPDATE user SET password=PASSWORD('123456') WHERE user='username';
FLUSH PRIVILEGES;