mysql> select user,host from mysql.user;

mysql> creat user 'glasssix' IDENTIFIED by '123!@#QWEasdzxc';
　　　　--默认 % %代表任何客户机都可以连接

mysql> creat user glasssix@"localhost" IDENTIFIED by '123!@#QWEasdzxc';
　　　　-- localhost 代表只可以本机连接

mysql> flush privileges;

mysql> show grants for glasssix

-- *.* 所有库表， db：*  某个库 ，tables_priv：db1.t1  某个表，columns_priv： 某列.

mysql>  grant select on *.* to glasssix;

# 授权select所有表的权限

mysql>  grant all privileges on *.* to glasssix;

# 授权所有的权限

mysql>  revoke select  on *.* from 'egon1'@'localhost';  　　

# 回收权限