mysql用户管理

导入数据库
新建数据库mysql>create database abc;
选择数据库mysql>use abc;
设置数据库编码mysql>set names utf8;
导入数据mysql>source /home/abc/abc.sql;

创建新用户

   create user username identified by 'password';

分配用户权限(所有权限)

    grant all privileges on ‘.’ to 'username'@'localhost' identified by 'password';

撤销刚才权限用root用户撤销刚才权限，并重新授权

    evoke all privileges on ‘.’ from 'username'@'localhost';
    grant all privileges on database.* to 'username'@'localhost' identified by 'password';

指定用户只能执行select和update命令：

    grant select,update on database.* to 'username'@'localhost' identified by 'password';

刷新权限

     flush privileges;

删除用户

     drop  user username@localhost;

查询相应的用户及对应的host

     select user,host from user;