添加用户:
CREATE USER 用户名 IDENTIFIED BY '密码';
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON *.* TO '用户名'@'%' identified by '密码';
FLUSH PRIVILEGES;(刷新权限)
查看用户列表:
查看所有用户(需要在root用户下进行)
select host,user from mysql.user;
删除用户:
mysql>Delete FROM user Where User='用户名' and Host='host名';//删除用户
mysql>flush privileges; //刷新权限
mysql>drop database 数据库名; //删除用户的数据库