mysql 用户操作

创建

GRANT ALL PRIVILEGES ON *.* TO '用户名'@'域' IDENTIFIED BY '密码' WITH GRANT OPTION;

CREATE USER '用户名'@'域'  IDENTIFIED BY 密码;

授权、更改

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP ON bankaccount.* TO '用户名'@'域' IDENTIFIED BY '密码';

删除

DROP USER 用户名

生效

FLUSH PRIVILEGES;