mysql 有关用户的操作

创建用户haven：

create user 'haven'@'localhost' identified by 'haven'; 只允许本地连接

create user 'haven' identified by 'haven'; 可远程连接的

授权：

grant all privileges on *.* to 'haven'@'localhost'; 将所有数据库的所有权限授权给本地的haven

删除用户：

delete from user where user='haven';

查看user和host：

mysql>use mysql;

mysq>select user,host from user;