MySQL用户操作命令

create user 'username'@'localhost' identified by 'password';--创建用户
set password for 'username'@'localhost'=password('newpassword');--修改用户密码
grant all on *.* to 'username'@'localhost';--授权
revoke all on *.* to 'username'@'localhost';--撤销授权
drop user 'username'@'localhost';--删除用户