mysql命令

0.root账户查看user系统权限表(权限表要使用名为mysql的系统数据库)
select host,user,password from user;

1.添加删除用户
CREATE USER 'itpro'@'%' IDENTIFIED BY '123';
DROP USER 'itpro'@'%';

2.用户授权

所有数据库所有权限给itpro其它机器连接
GRANT ALL PRIVILEGES ON *.* TO 'itpro'@'%' IDENTIFIED BY '123'WITH GRANT OPTION

bb数据库部分权限itpro本地机器连接
grant select,insert,update,delete,create,drop on bb.* to itpro@localhost identified by ‘123′;

bb数据库cc表部分权限itpro指定IP连接
grant select,insert,update,delete,create,drop on bb.cc to itpro@10.122.132.144 identified by ‘123′;

3.刷新系统权限表
mysql>flush privileges;

4.显示用户权限
mysql>show grants;

5.显示数据表结构
mysql>describe 表名;